Written by Allen Wyatt (last updated December 7, 2021)
This tip applies to Excel 97, 2000, 2002, and 2003
Defining names in an Excel worksheet is a common task, and many worksheets can end up with many, many named ranges. You can, of course, jump to a range name by using the Go To dialog box (press F5).
One little-known tip allows you to see all your named ranges at once, rather than jumping to them individually. Simply change the Zoom factor for your workbook to 39%, and the named ranges are shown on-screen as "blocked" areas. This works only when the Zoom factor is 39% or less; at 40% or greater, the named ranges are not marked. It also only shows named ranged occupying two cells or more; single-celled named ranges are not shown.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3052) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Where Is that Name?.
Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results. This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables. Check out Microsoft Excel 2013 Data Analysis and Business Modeling today!
A little green triangle in the corner of a cell means that Excel thinks there is an error with the cell contents. If ...
Discover MoreIf your worksheet gets big enough, it is easy to spend a lot of time navigating back and forth between different areas. ...
Discover MoreReferring to cells is typically done using a letter and a number, which represent the column and row. That's not the only ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments