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.