Find named ranges - Microsoft Support (2023)

So, you've named a range of cells, and ... perhaps you forgot the location.You can find a named range by using the Go To feature—which navigates to any named range throughout the entire workbook.

  1. You can find a named range by going to the Home tab, clicking Find & Select, and then Go To.

    Or, press Ctrl+G on your keyboard.


  • The Go to popup window shows named ranges on every worksheet in your workbook.

  • To go to a range of unnamed cells, press Ctrl+G, enter the range in the Reference box, and then press Enter (or click OK). The Go to box keeps track of ranges as you enter them, and you can return to any of them by double-clicking.

  • To go to a cell or range on another sheet, enter the following in the Reference box: the sheet name together withan exclamation point and absolute cell references. For example: sheet2!$D$12 to go to a cell, and sheet3!$C$12:$F$21 to go to range.

  • You can enter multiple named ranges or cell references in the Reference box. Separating each with a comma, like this: Price, Type, or B14:C22,F19:G30,H21:H29. When you press Enter or click OK, Excel will highlight all the ranges.

More about finding data in Excel


Find named ranges - Microsoft Support? ›

You can find a named range by going to the Home tab, clicking Find & Select, and then Go To. Or, press Ctrl+G on your keyboard. In the Go to box, double-click the named range you want to find.

How do I find unused named ranges in Excel? ›

How to Find Unused Names in Excel
  1. Open the workbook that you want to check for unused names.
  2. Click on the "Formulas" tab in the ribbon.
  3. Click on "Name Manager" in the "Defined Names" group.
  4. In the Name Manager dialog box, look for any names that have a "Refers to" value of "#REF!".
Apr 5, 2023

Does Excel online support named ranges? ›

In Excel for the web, you can use the named ranges you've defined in Excel for Windows or Mac. Select a name from the Name Box to go to the range's location, or use the Named Range in a formula. For now, creating a new Named Range in Excel for the web is not available.

How do I select all named ranges? ›

To select all named ranges, simply press the Shift key. And if your intention is to delete only a few named ranges, hold down the Ctrl key and the select those ranges to delete.

How do I quickly delete all named ranges in Excel? ›

In case you want to select a block of Named Ranges in one go, select the first one, hold the SHIFT key, and then select the last one. This will select all the Named Ranges in between and you can delete all of these in one go.

How do I find a named range in sheets? ›

Name a range
  1. Open a spreadsheet in Google Sheets.
  2. Select the cells you want to name.
  3. Click Data. Named ranges. A menu will open on the right. ...
  4. Type the range name you want.
  5. To change the range, click Spreadsheet .
  6. Select a range in the spreadsheet or type the new range into the text box, then click Ok.
  7. Click Done.

How do I find named ranges in Excel 365? ›

You can find a named range by using the Go To feature—which navigates to any named range throughout the entire workbook. You can find a named range by going to the Home tab, clicking Find & Select, and then Go To. Or, press Ctrl+G on your keyboard.

Does the online version of Excel have all features? ›

This is because Excel online is exclusively internet-dependent. Not all file formats are endorsed. Compared to the desktop app, there are some missing features – especially: Macros and VBA. Excel Online is just not the spreadsheet program for you if you have a large dataset ahead of you.

How do you select all name ranges in Excel? ›

To select two or more named cell references or ranges, click the arrow next to the Name box, and then click the name of the first cell reference or range that you want to select. Then, hold down CTRL while you click the names of other cells or ranges in the Name box.

How do I edit multiple named ranges in Excel? ›

How to edit named ranges in Excel
  1. Navigate to the "Formulas" tab.
  2. Locate "Name Manager."
  3. Select the named range that you want to edit.
  4. Type the new name in the "Name" line in the "Edit Name" box.
  5. Press "OK."
  6. Click "Close" on the "Name Manager" box.
Jun 24, 2022

How do I view and edit named ranges in Excel? ›

On the Formulas tab, in the Defined Names group, click Name Manager. In the Name Manager dialog box, double-click the name you want to edit, or, click the name that you want to change, and then click Edit.

How do I find the address of a named range? ›

Get Address of Named Range

In order to get the full address of a named range, we'll find the first and last cell references of the named range and then join them together with a colon (“:”).

How do I unhide or delete a name range in Excel? ›

You can delete or change unwanted named ranges using the Excel Name Manager.
  1. Select the Fomulas ribbon and, under the 'Defined Names' group, click on 'Name Manager'
  2. In the Name Manager select the name (or names) to be deleted and press the 'Delete' button:
Mar 21, 2022

How do I delete unused ranges in Excel? ›

How to remove blank cells in Excel
  1. Select the range where you want to remove blanks. ...
  2. Press F5 and click Special… . ...
  3. In the Go To Special dialog box, select Blanks and click OK. ...
  4. Right-click any of the selected blanks, and choose Delete… from the context menu:
Mar 16, 2023

How do I unhide hidden names in Excel? ›

Selectively Display Hidden Worksheets
  1. Click the Home tab > Format (in the Cells group) > Hide & Unhide > Unhide Sheet.
  2. Click the name of the sheet you want visible and click OK.
  3. The sheet is now visible.

How do I delete a named range in sheets? ›

How to Delete a Named Range in Google Sheets?
  1. Go to Data > Named ranges. Named Ranges in Google Sheets (Complete Guide) - Data > Named Ranges.
  2. Select the named range you want to delete and click the pencil icon. ...
  3. Click the trash can icon next to the range name to delete the named range.
Jan 31, 2023

What is a named range? ›

A named range is just a human-understandable name for a range of cells in Excel. Using the name range in Excel, you can simplify and comprehend your formulas better. For example, you can assign a name for a range in an excel sheet for a function, a constant, or table data.

How do you use a named range in data validation list? ›

Using named ranges

All you need to do is to select the column that holds your list items and give a name to it. The simplest way is to type a "valid" name into the reference box and press Enter after selecting the column. Once the named range is created, you can use it within data validation list.

How do I select cells or ranges in Excel 365? ›

Select one or more cells

Click on a cell to select it. Or use the keyboard to navigate to it and select it. To select a range, select a cell, then with the left mouse button pressed, drag over the other cells. Or use the Shift + arrow keys to select the range.

What is the name range manager? ›

The Name Manager is a dialog box in Excel that allows you to create, edit, and delete defined names. These names can be named ranges, named formulas, and named constants. Using named ranges can make formulas easier to read, understand. and maintain Names also provide simple navigation via the Name Box.

How do I enable name manager in Excel? ›

Excel “Name Manager” can be found in the “Formulas” tab. Tip: “Ctrl + F3” is the shortcut to access it. Usually, it is used to work with existing names. However, it also allows you to create a new name too.

What two features are not supported in Excel in Office 365 online? ›

Excel Online doesn't offer the following features from the Data menu:
  • Data import from external sources, such as databases or text files.
  • Advanced filtering options.
  • Several features in the Data Tools group, including flash fill, relationships, text to columns, and consolidate.
Apr 4, 2022

Is Excel different in Office 365? ›

Microsoft 365 plans include Office 2021 as a part of a greater offering. It also includes Windows 10 Enterprise, Enterprise Mobility + Security (EMS), and machine learning. There are multiple plans to choose from depending on your needs. The services included in Microsoft 365 are also available as separate licenses.

Why is Excel 365 different from Excel? ›

Excel 365 is the subscription-based version of Excel and Excel 2019 is the perpetual, stand-alone, bought-outright version. A perpetual license has always been made available by Microsoft for outright purchase and outright ownership.

What is the disadvantage of using named ranges? ›

The other common criticism of named ranges is that formulas end up with lots of '+' and '@' symbols in their formula, as people don't understand them. All these symbols do is tell Excel to refer to the specific column of the range the formula is in rather than the entire row.

How many named ranges are there in Excel? ›

There are two types of named ranges and it is possible to use both types in the same workbook. Workbook - These can be referenced from any worksheet in the workbook. Worksheet - These are worksheet specific and can only be referenced on that particular worksheet.

Why can't I edit named ranges in Excel? ›

To help fix the issue Select the Locked check box in the Named Range dialog box when you create the named range. To lock or unlock a named range after it has been created: On the Sheet menu, point to Named Range and choose Manage. In the Named Ranges dialog box, select the named range and click the Edit button.

How do you Create a dynamic named range? ›

How to create a dynamic named range in Excel
  1. On the Formula tab, in the Defined Names group, click Define Name. Or, press Ctrl + F3 to open the Excel Name Manger, and click the New… ...
  2. Either way, the New Name dialogue box will open, where you specify the following details: ...
  3. Click OK.
Mar 20, 2023

How do I replace a named range in Excel? ›

Start by selecting the cells that contain formulas you want to update. Then run Formulas > Define Names > Apply Names. Excel will then replace references that have a corresponding named range with the name itself.

Do named ranges slow down Excel? ›

The only problem is that named ranges, especially dynamic ranges, consume a considerable amount of working memory. Overusing them may slow down your Excel spreadsheet.

How do I find and delete hidden names in Excel? ›

How to unhide or delete name ranges in Excel?
  1. Delete all the visible name ranges. Do this by pressing Cntrl+F3.
  2. Highlight all the name ranges you want to delete, and press delete. I don't use name ranges, so I just delete all. ...
  3. Just a warning – a print area are also a “name range”. ...
  4. Click “Delete”
  5. Confirm by clicking “OK”

How do I get rid of thousands of extra rows in Excel? ›

You can remove blank rows in Excel by first doing a "Find & Select" of blank rows in the document. You can then delete them all at once using the "Delete" button on the Home tab. Once rows or cells are deleted in Excel, the data below them will move upwards.

How do I delete all named ranges in Excel macro? ›

Click on the Name Manager option in the Defined Names section of the Formula tab.
  1. How to delete a Named range in Excel using Name manager?
  2. Select all the named ranges you want to delete and press the Delete button.
  3. Click on the FIlter button inside the Name Manager.

How do you remove the name already exists in Excel? ›

You can try these steps to get rid from the issue.
  1. Close all open Workbooks if any & shut down Excel.
  2. Restart Excel and then open the workbook.
  3. Press Ctrl+F3 and filter the named ranges on errors.
  4. Delete all erroneous named ranges.
  5. Finish with OK.
  6. Save & close the workbook.
Sep 21, 2018

How do I find super hidden tabs in Excel? ›

Right click on any visible tab. Select Unhide. Mark the tabs to unhide. Click OK.

How do I break a ghost link in Excel? ›

Check for Object Links
  1. Links can exist in Object such as text boxes, auto shapes or drawing objects.
  2. On each worksheet, press the F5 key, click the “Special” button and select “Objects”
  3. Delete these objects and then save the file.


Top Articles
Latest Posts
Article information

Author: Msgr. Refugio Daniel

Last Updated: 02/10/2023

Views: 6344

Rating: 4.3 / 5 (54 voted)

Reviews: 85% of readers found this page helpful

Author information

Name: Msgr. Refugio Daniel

Birthday: 1999-09-15

Address: 8416 Beatty Center, Derekfort, VA 72092-0500

Phone: +6838967160603

Job: Mining Executive

Hobby: Woodworking, Knitting, Fishing, Coffee roasting, Kayaking, Horseback riding, Kite flying

Introduction: My name is Msgr. Refugio Daniel, I am a fine, precious, encouraging, calm, glamorous, vivacious, friendly person who loves writing and wants to share my knowledge and understanding with you.