If you attempted to merge cells together within a table in Microsoft Excel, you may have faced the grayed out “Merge and Center” button issue.
To work around this problem, do the following :
1. Select the cells that you want to merge
2. Right click on the selection
3. In the context menu, click on “Table”
4. Then click “Convert to Range” option.
If the Table option isn’t showing up at step 3, this mean that the selection isn’t a part of a table, therefore the Merge and Center button should be available to click on the top menu under the Home tab.