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