Find named ranges

So, you've named a range of cells, and ... where was it again? You can find a named range by going to the Home tab, clicking Find & Select, and then Go To. You can then go to named ranges on any worksheet in your workbook.

1. Press Ctrl+G.

You can also click Home > Find & Select > Go To.

1. In the Go to box, double-click the named range you want to find.

Notes: 

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

• If you want to go to a range of unnamed cells, press Ctrl+G, enter the range in the Reference box and 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 sheet name, an exclamation point, and then absolute cell references in the Reference box. 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. Separate them with commas, like so: Price,Type, or B14:C22,F19:G30,H21:H29. When you press Enter or click OK, Excel highlights all the ranges.

More about finding data in Excel

• Find or replace text and numbers on a worksheet

• Find merged cells

• Remove or allow a circular reference

• Find cells that contain formulas

• Find cells that have conditional formats

• Find hidden cells on a worksheet