As part of the Excel Hero Academy that I’ m now doing, one of the first things we did was learn more about named ranges. Daniel Ferry showed us a really useful trick that allows you to view your ranges (with their names on their sheet).
The trick is to reduced the zoomed view (View – Zoom – Custom -put in number less than 40%) to see your named ranges.
See the video below to see how it’s done
[flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/zooming_named_ranges.mp4′]
For practice, create some named ranges and try this out…