How to

Why you should never merge cells in spreadsheets

Why you should never merge cells in spreadsheets

Why you should never merge cells in spreadsheets

Never merge cells in spreadsheets

Never merge cells in spreadsheets

Never merge cells in spreadsheets

Aug 22, 2022

Aug 22, 2022

Merged Cells Example
Merged Cells Example

When polling spreadsheet users, the ability to merge cells is highly controversial: people from high-finance backgrounds hate it while very casual users are often ambivalent to it.

The strong reaction from the finance folks comes from the fact that merging cells ruins their sacred A1 grid framework, and this is true. When you merge a cell, it treats the all of the cells that have been merged as one cell. Consequently, you lose the dimensions of some of the cells that have been merged. In this example below, A1, B1, and C1 have been merged and therefore there is no way to move another cell into the cells B1 or C1.

This is problematic for number crunchers in other ways as well. In the same example above, if you wanted to highlight everything in column B and use the “select column” shortcut, it would automatically grab all the columns of the merged cell and not column B. That feature alone prevents you from formatting or deleting just column B. Similarly, you could have a formula somewhere that referenced cell B1. To the human eye, it would look like the contents of B1 are the same as “A1,” but in reality, the contents are actually blank since the merge feature deletes all of the contents not in the upper left most cell.

The more elegant solution is to use Center Across Selection, which gives the same appearance: the contents in A1 centered across cells A1, B1, and C1.

The problem is that this feature tends to be hidden away and used only by those who know about it (like most spreadsheet features). And even for the power users, it is a ton of keystrokes and shortcut keys to remember. But it’s the best alternative since you can still edit the cells individually.

Anytime you’re tempted to use the merge cells function, try Center Across Selection instead, so you don’t break your analysis.

When polling spreadsheet users, the ability to merge cells is highly controversial: people from high-finance backgrounds hate it while very casual users are often ambivalent to it.

The strong reaction from the finance folks comes from the fact that merging cells ruins their sacred A1 grid framework, and this is true. When you merge a cell, it treats the all of the cells that have been merged as one cell. Consequently, you lose the dimensions of some of the cells that have been merged. In this example below, A1, B1, and C1 have been merged and therefore there is no way to move another cell into the cells B1 or C1.

This is problematic for number crunchers in other ways as well. In the same example above, if you wanted to highlight everything in column B and use the “select column” shortcut, it would automatically grab all the columns of the merged cell and not column B. That feature alone prevents you from formatting or deleting just column B. Similarly, you could have a formula somewhere that referenced cell B1. To the human eye, it would look like the contents of B1 are the same as “A1,” but in reality, the contents are actually blank since the merge feature deletes all of the contents not in the upper left most cell.

The more elegant solution is to use Center Across Selection, which gives the same appearance: the contents in A1 centered across cells A1, B1, and C1.

The problem is that this feature tends to be hidden away and used only by those who know about it (like most spreadsheet features). And even for the power users, it is a ton of keystrokes and shortcut keys to remember. But it’s the best alternative since you can still edit the cells individually.

Anytime you’re tempted to use the merge cells function, try Center Across Selection instead, so you don’t break your analysis.

Ready to start?

Sign up for the alpha.

Ready to start?

Sign up for the alpha.

Ready to start?

Sign up for the alpha.