The Merge And Center button is grayed out in Excel as the selected cells are in a formatted table. An Excel sheet with a row selected and the Alignment icon highlighted.

Microsoft Excel has numerous powerful data analysis functions, but sometimes you need to do something simple like merge some cells. Here's how.