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.