What’s so Special about Zoom 39%

I’m here in Arkansas for the Excel BI Boot Camp. Within one hour of arriving Bob Umlas (long-time MVP veteran) showed me a trick I didn’t know. He asked me:

“Do you know what’s special about zooming your spreadsheet to 39%?”

I said: “Uhh…..nope.”

.

Apparently, when you zoom your spreadsheet to 39% or less, Excel will automatically show you any Named Ranges in a watermark.

.

For example, let’s say I have three ranges named Larry, Curly, and Moe.

.

When I zoom my spreadsheet to 39%, I get this view.

Well I’ll be darned!

See how Excel tags each named range.

.

This could come in handy if you ever need to quickly see which named ranges are used on the sheet you’re on.

.

Unfortunately, this trick becomes less effective if you use the same cells in multiple Named Ranges. For instance, I included my three ranges in a new named range called Stooges.

.

Thanks Bob for another trick that’s almost useful.

 

8 thoughts on “What’s so Special about Zoom 39%

  1. Jon Acampora

    It also does not work for dynamic ranges. It would be cool if it displayed table names when you zoom out though. Add two to the wishlist…

    Thanks for sharing Mike!

  2. Chris Macro

    Not sure if I’ll every use it, but it’s a pretty cool “easter egg”. Might be cool to write a macro that zooms out to 39% to reveal the named ranges that you can toggle back and forth. Thanks for sharing it Mike!

  3. MF

    And it doesn’t work when the NameRange contains only one cell.

    To find out the named range, I prefer
    F3 –> Paste List

Leave a Reply

Your email address will not be published. Required fields are marked *