When the Merge and Center button is missing, greyed out, or not working in Excel, there are two possibilities ... go to Horizontal heading. Click the drop-down arrow and choose the Center Across ...