Tip #163_Excel

Excel: Quick Range Names

 

For intermediate and advanced Excel users, RANGE NAMES are a terrific time-saving feature.

 

But if you have a spreadsheet that contains a lot of range names, you might find yourself forgetting some of the names and having to: open the NAME box to display all the range names – then clicking a name to see what range of cells it represents. And that’s the fast method – going through the FORMULAS tab is more cumbersome.

 

A much faster way to see your range names…

 

Full tip: Excel tip