Spreadsheet Tips

How to Center Data Across a Selection in Excel

September 07, 2018
How to Center Data Across a Selection in Excel

Have you ever used Merge and Center in Excel?

It's a fine feature, but it comes with some problems. It makes formulas complicated, and it's hard to pick it up and move the data. It's better to center data across a selection as you can see in the tip above.

With this approach, all of your data lives in a single cell, but it centers the data over the columns. Try out this tip instead of the merge and center approach to keep your spreadsheet more usable and not create complicated formulas to workaround centered data.