Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

XL2K - "Merge" option greyed out - why? 1

Status
Not open for further replies.
MeGustaXL

MeGustaXL

Technical User
Aug 6, 2003
1,055
GB
The subject says it all; somebody else's workbook, I want to merge 6 cells in a column, Format > Cells > Alignment and Merge is checked but greyed out!

There are no macros in the workbook
No protection set

Help!

Chris

Servo vestri abbas etiam quod ego mos arcesso unguentum
 
Sort by date Sort by votes
Check to see if it's a shared workbook. Go to Tools, Share Workbook. If the Allow changes box is ticked, then you can't merge cells. You would have to un-share it first.
 
Upvote 0 Downvote
Spot On, Molby!

Have a STAR!



Chris

Servo vestri abbas etiam quod ego mos arcesso unguentum
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

OCM
  • Question
Mail merge with details
Replies
2
Views
399
OCM
OCM
ladyck3
  • Locked
  • Question
Excel 365: I'm new to Tables - Configuring Font & "Get Data from Table/Range" 2
Replies
4
Views
147
ladyck3
ladyck3
ladyck3
  • Locked
  • Question
Excel 365: [SOLVED ]Data Dump Date: "Jul 12 20:27:14 CDT 2022" convert to 07/12/2022 2
Replies
8
Views
131
ladyck3
ladyck3
Flavescent
  • Locked
  • Question
Excel 365 - like a cut out figure
Replies
4
Views
184
SkipVought
S
GPnew
  • Locked
  • Question
Power Pivot Filter out Rows where data is not in all columns
Replies
14
Views
472
combo
combo

Part and Inventory Search

Sponsor

Back
Top