I Know I Put That Name Someplace!


excel logoFolks define names in their Excel worksheets all the time and they can sometimes end up with so many names that they have difficulty remembering them or finding them! Of course, you can can jump to a named range by clicking on F5 to open the dialog box.

There is, however, a little trick that will allow you to see all your named ranges at one time rather than going to each on individually. Not a lot of folks know about this but I’m going to share it with you!

Follow the steps below:

All you really have to do is change the Zoom factor for your workbook to 39% and you will then see the named ranges on screen as blocked area.

Make note, that this will only work for you when your Zoom factor is 39% or less. At 40% or greater, the named ranges are not marked and single cell ranges are not shown at all.

About the Author

Carol Bratt

Carol holds A+, MCP, and MOS computer certifications and is the resident DCT Office expert. She trains the staffs of small law firms in the use of Microsoft Office applications and has authored many books covering Microsoft Office as well as written articles for Infopackets, TechnoLawyer, and Digital Harbor. For more Microsoft Office tips visit Carol's Corner Office or follow Carol on FaceBook and Twitter.