Awesome Excel tip #6

Quick-naming a range

We often use absolute cell references or named ranges. I find it easier to teach my students to name their cells or use named ranges instead as it makes it much easier to understand and work with functions and formulas.

This shortcut is so super-easy and quick, it makes naming a range of cells a piece of cake!

Demonstration

About Matthew Hains 782 Articles
Matthew is a Computer Applications Technology teacher at an independent school in South Africa.