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…