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=’′]

For practice, create some named ranges and try this out…