Delete range names with #REF errors

A macro to the rescue

Here is an example of a simple macro that solves a problem in Excel 2003 and earlier versions.

Range names can be corrupted if a cell that they refer to gets deleted. This doesn’t mean that the cell value gets deleted, but the cell itself is removed from the sheet.

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.