Beware Excel’s Merge and Center format

Purge the Merge

Ever had an error message which stated that you “Cannot change part of a merged cell”?

Well the merge format is the culprit. The Merge and Center icon on the Home ribbon is commonly used to format headings to make them look good by centering a heading across the cells below it.

Copy formats quickly with the Format Painter

Do you know the mouse trick?

One of Excel’s most useful Ribbon / toolbar icons is the Format Painter.

To use it first select a cell or range that has the format you want to use. Then you click the Format Painter icon and click another cell to apply all the formats that the original cell had.