Formulas · original practice scenario
Focus the Name Box without changing the selection
Select B2:B4 and note the current address shown beside the formula bar.
Start here: Windows desktop Excel 2016 or later; focus in the worksheet grid
The publisher scopes this Windows shortcut to Excel 2016 onward. Mac pane cycling is an alternative workflow, not an equivalent direct binding; no Mac binding is assigned.
Follow these instructions in your own desktop Excel workbook. This page explains the operation; it does not send commands to Excel.
Mac keys and context
This catalog has no verified Mac binding for this operation. The steps below describe Windows. Choose Windows to use the walkthrough and recall controls.
Walk through the operation
- Use the listed chord to focus the Name Box above the grid.
- Confirm that B2:B4 remains selected; pressing the chord alone does not name or move the range.
- Press Esc to return focus without entering a new name or address.
Expected result: Keyboard focus reaches the Name Box while the worksheet selection remains unchanged.
Related walkthroughs
- Evaluate a selected formula fragment
- Accept the highlighted formula autocomplete item
- Inspect names in Name Manager
Catalog updated 2026-10-18. US keyboard notation: + joins held keys; commas separate successive presses. Function keys may require Fn. Desktop instructions are separate from this browser's own keyboard shortcuts.