Skip to content

↑↓ moveEnter openEsc close

Select cells directly referred to by the formula in the active cell in Excel

Excel Microsoft 365 · 119 shortcuts · checked Nov 2026 · Source: Microsoft docs

In Microsoft Excel, press Ctrl+[ on Mac, Windows.

What else uses Ctrl+[?

More Excel shortcuts: select

ActionMacWindows
Select the entire worksheetCmdACtrlA
Select the current region around the active cellCtrlShift8CtrlShift8
Select the entire columnCtrlSpaceCtrlSpace
Select the entire rowShiftSpaceShiftSpace
Extend the selection by one cellShift→Shift→
Extend the selection to the last nonblank cell in the same row or columnShiftCmd→CtrlShift→
Extend the selection to the beginning of the rowShiftHomeShiftHome
Extend the selection to the beginning of the worksheetCtrlShiftHomeCtrlShiftHome
Extend the selection to the last used cell on the worksheetCtrlShiftEndCtrlShiftEnd
Extend the selection down one screenShiftPageDownShiftPageDown

All 17 in select · All 119 Excel shortcuts