Alternative to Merged Cells (Quick Tip)

Typically, many users are drawn to the Merged Cells feature in Excel, despite it having some significant disadvantages (especially related to copy/paste of ranges).

Frequently, Merged Cells are used in areas to group cells together visually, which can be done differently without causing the issues that merging does.

You can use an option within formatting called ‘Center Across Selection’ which takes the text from the leftmost cell of a range and centers it across the selected range.

Here is a screenshot of how to find it / use it by right clicking on a range and going to ‘Format Cells’. ┬áThen click the Alignment tab as shown below (the Center Across Selection option):

 

Voila! The text is centered across multiple cells without the need for merging them.

You can also remove the gridlines in Excel to make it look a bit cleaner.

That option can be found here under the ‘View’ tab:

This entry was posted in Quick Tips and tagged , , , , . Bookmark the permalink.

6 Responses to Alternative to Merged Cells (Quick Tip)

  1. dasimons says:

    Damn that’s useful.

  2. Anonymous says:

    hi is there a keyboard shortcut for the remove grid lines and the centered across selected cells?

  3. Anonymous says:

    same question… how to apply it to columns? Thank you very much

    • Hey Anonymous,

      Sorry, I had responded to Jawed’s comment via email originally:

      “Unfortunately, there is not a similar method for doing it vertically.

      Perhaps that will be fixed in future versions. There may be workarounds, but I would suggest googling it to see depending on your needs.”

      Cheers,

      Ben

  4. Jawed says:

    How can I apply the same method to the column cells?

Leave a Reply