Named Ranges

Named ranges let you give meaningful names to cell ranges for easier formulas.

Defining a Named Range

1. Select the cells you want to name
2. Press Ctrl+Shift+N
3. Enter a name (e.g., “SalesData”)
4. Press Enter

Now you can use this name in formulas: =SUM(SalesData)

Go to Definition (F12)

When your cursor is on a named range in the formula bar, press F12 to jump to the cells that define that range.

Find All References (Shift+F12)

Select any cell and press Shift+F12 to see all cells that reference it. A popup shows:

• List of cells containing formulas that depend on the current cell
• Preview of each formula
• Click or press Enter to navigate to a reference

Rename Symbol (Ctrl+Shift+R)

To rename a named range across all formulas:

1. Put your cursor on the name in any formula
2. Press Ctrl+Shift+R
3. Enter the new name
4. Press Enter to apply

All formulas using that name are updated automatically.