Excel Alt key shortcuts

Keyboard shortcuts rule

The ALT key (there’s one on either side of your Spacebar) has some really useful shortcuts. See if they can save you some time and effort. These can be handy if, like me, you sometimes struggle with your laptop’s built-in mouse controller and you don’t have your external mouse handy. And remember most keyboard shortcuts work in all versions of Excel.

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.