Please Note: This article is written for users of the following Microsoft Excel versions: 2007 and 2010. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Printing a List of Named Ranges.
Anyone who has created a large workbook knows that it is very easy to create a large list of named ranges. Managing those ranges, particularly if you inherit the workbook from someone else, is a much harder task. Part of the problem is that you may lose track of all your ranges and what they refer to.
Having a list of the names in your workbook could be helpful. To get a list, follow these steps:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (7731) applies to Microsoft Excel 2007 and 2010. You can find a version of this tip for the older menu interface of Excel here: Printing a List of Named Ranges.
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!
If you want to automatically print a particular area of your worksheet at a specific time of day, you'll love this tip. With ...
Discover MoreExcel allows you to easily print an entire workbook. Doing so, however, may not give the desired results if you a printing ...
Discover MoreNeed to print a portion of a worksheet, but don't want to waste paper by printing the whole thing? It's easy to print just ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2017-06-14 12:29:18
Bill Bosler
just tried above for Excel 2016 Mac and it doesn't work. I can display the names {fig}
{fig} doesn't seem to work in Chrome on Mac.
I can display and select all names in "Apply Names"; but, can't copy or anything else???
2017-06-14 12:26:45
Bill Bosler
just tried above for Excel 2016 Mac and it doesn't work. I can display the names {fig}
2017-05-08 04:42:32
Chris
Thanks for this - can it also work backwards? i.e. would it be possible to edit the ranges via some sort of list?
2017-02-20 10:24:39
Eric Hall
Thanks, large inherited files are a pain. This helps a bunch.
2015-07-05 02:50:20
Dave Roberts
I am using Excell on my Mac - 2011 Version and the method suggested does not work for this version - there is no "Defined Names" Group in the Formula tab of the Ribbon.
My Work-around is to create the tabular listing off to the right of the spreadsheet temporarily and select the first cell. The Define Names Group has been moved into the Insert Menu. Use the Paste option to paste the listing into the temporary area. You can then Copy and Paste this to a new Spreadsheet and delete the original temporary dump
2015-05-01 04:44:14
Willy Vanhaelen
You can replace step 2, 3 and 4 with simply pressing [F3].
2015-03-25 11:13:35
Linda Vallejos
Thank you. This was just what I needed.
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2017 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 2007 and 2010. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: 
Comments