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

A Picture is Worth Thousands! Your worksheets are not limited to holding numbers and text. You can also add graphics or easily create charts based on your data. Excel Graphics and Charts, available in two versions, helps you make your graphics and charts their absolute best.

Check out Excel Graphics and Charts today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Merge and Center Not Available