Select Name Box in Excel
The Name Box shows the address or name of the currently selected cell or range. Selecting it allows you to quickly jump to cells or define named ranges.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Ctrl + F3 → Tab (or F5 then Tab) | Not available (click manually) |
How to Select the Name Box
- Press Ctrl + F3 and close the dialog, or press F5 then Tab
- The cursor moves to the Name Box
- Type a cell reference (e.g., A1) or a name
- Press Enter to jump to the location
Tips & Best Practices
- Use the Name Box to quickly navigate large worksheets
- Type a new name to create a named range instantly
- Combine with Name Manager for advanced range control
FAQ
- Q: Can I create a named range from the Name Box?
- Yes, select a range, type a name in the Name Box, and press Enter.
- Q: Does the Name Box work with named tables?
- Yes, table names also appear in the Name Box.