An alternative to merged cells

You spend hours formatting your excel file by merging cells, wrapping text, using middle align and a whole host of other formatting to get your excel file just right and then the following error message pops up:

Or another familiar message

So you end up undoing everything you just did

Or you try and add up a number of rows but then run into a merged cell heading which stops you in your tracks

Instead of using merged cells

Try this instead

Centre Across Selection

How to use Centre Across Selection

Watch Video

Step by Step Instructions

In the below example, we will centre align the year 2022. Select cells B1 to D1

Press Ctrl 1 to bring up the Format Cells pop up box

On the alignment tab, under the Horizontal drop down select "Centre Across Selection" and click OK

The date looks like it is centred through a merge cell but now you have the flebility to move across rows without being hampered by a merged cell

You can scroll down rows if need to

And there you have it. Centre Across Selection

Stay ahead with the latest in data visualisation — insights, tools, and trends delivered straight to your inbox.