91. Excel Tips - Display All Range Names

Managing Range names can be fiddly, but this tip makes it a lot easier:
- There's a way to actually view the range names
- Simply change the View zoom to 39%
- Why 39% ? I have no clue but it works
- It is useful to see the range names on the sheet so you can clean up ones you don't use, and make sure tables have the correct size
Normal view:
View with range names on display:
Download sheet to practise how to Display All Range Names in Excel
Training Video on how to Display All Range Names in Excel:
Attachment | Size |
---|---|
display-all-range-names.xls | 844 KB |
»
- Nick's blog
- Login or register to post comments
- 14840 reads
91. Excel Tips - Display All Range Names
It's actually any zoom smaller than 40%.
Excel Tips - Display All Range Names
y... it's 10% (the min) => 39%... odd that it stops at 39% though..