How to Merge and Center several rows of heading at once in Excel

You are likely familiar with Excel’s Merge & Center command which is a great way to centre a heading across the width of the spreadsheet.

Yet, as you have probably discovered, if you have several lines of heading and try to Merge and Center them all at once, it turns all the selected cells into one large cell and only keeps the text in the first row.

Rather than using Merge & Center on each row, use the Merge Across command as it will merge several rows at once, keeping each row.

To merge and center several rows of headings at once:

 

  1. Select the cells with text and as many columns as you need to
  2. Click on the drop down arrow next to the Merge & Center button
  3. Select Merge Across
  4. Click on the Center button


Merge Across doesn’t center the text across the merged cells so you’ll need to do that yourself.

Any questions, please let me know.