Instead, check to see if Center Across Selection will do the trick for you. In many instances, your best bet is to simply not use the Merge and Center tool. The only solution in this case is to convert the table to a range, and then you can once again access the tool. If the cells are part of a formatted table (the Format as Table tool, on the Home tab of the ribbon was used), then you cannot merge cells within the table. The third potential cause is if the cells you've selected are in a table, instead of a range of cells. 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. (Actually, they disable a lot of other commands in addition to Merge and Center.) Both protection and sharing have been discussed in other issues of ExcelTips, and both of them happen to disable Merge and Center. Second, you should check to see if the workbook is shared. You should check, first, to see if your worksheet is protected. He wonders if there is some combination of formats or settings that disables the tool.Īctually, there are at least three conditions that can cause the Merge and Center tool to be unavailable. However, the tool is continually grayed out on his worksheet and Paul can't figure out why. Paul has a worksheet in which he wants to apply Merge and Center to a selection.
0 Comments
Leave a Reply. |