Merge and Center Not Available

Summary: What are you to do if you are trying to format a worksheet, only to find out that one of the tools you need is not available? The reason could be simple; this tip looks at why the Merge and Center tool might be unavailable when working in a workbook. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

Paul has a worksheet in which he wants to apply Merge and Center to a selection. However, the tool is continually grayed out on his worksheet and Paul can't figure out why. He wonders if there is some combination of formats or settings that disables the tool.

Actually, there are two conditions that can cause the Merge and Center tool to be unavailable. You should check, first, to see if your worksheet is protected. Second, you should check to see if the workbook is shared. Both protection and sharing have been discussed in other issues of ExcelTips, and both of them happen to disable Merge and Center. (Actually, they disable a lot of other commands in addition to Merge and Center.)

If you turn off sharing (if it is on) and disable protection (if it is protected), then the tool should once again be available.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (5398) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Save Time! ExcelTips has been published weekly since late 1998. Past issues of ExcelTips are available in convenient ExcelTips archives. Have your own enhanced archive of ExcelTips at your fingertips, available to use at any time!

Check out ExcelTips Archives today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Merge and Center Not Available