Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Merge and Center Not Available.
Written by Allen Wyatt (last updated December 14, 2019)
This tip applies to Excel 97, 2000, 2002, and 2003
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 the worksheet 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 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Merge and Center Not Available.
Program Successfully in Excel! This guide will provide you with all the information you need to automate any task in Excel and save time and effort. Learn how to extend Excel's functionality with VBA to create solutions not possible with the standard features. Includes latest information for Excel 2024 and Microsoft 365. Check out Mastering Excel VBA Programming today!
This tip contains a macro to hide rows that contain data you don't want to see.
Discover MoreIf you ever get to a situation where you can no longer format cells in a workbook, you'll realize just how important the ...
Discover MoreThe error message "too many cell formats" can be difficult to fix. This tip describes ways you can attempt to get rid of ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2020-12-07 17:52:09
Excel User
It would be great if you actually explained the steps to do this though. Off to google them now .
2020-08-13 17:00:01
Kaaleeswaran
Thank you. Your portal helped me in lot of times where I need help in Excel.
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here:
Comments