Skip to content

↑↓ moveEnter openEsc close

Cycle through absolute and relative references in a formula in Excel

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

In Microsoft Excel, press Cmd+T or F4 (Mac), F4 (Windows). Works when: editing a cell reference.

Either combination works; the keyboard shows the first. What else uses Cmd+T? · What else uses F4?

More Excel shortcuts: enter data and formulas

ActionMacWindows
Edit the active cell and put the insertion point at the end of its contentsCtrlUorF2F2
Start a new line in the same cellCtrlOptionEnterorOptionCmdEnterAltEnter
Fill the selected cell range with the current entryCtrlEnterCtrlEnter
Complete a cell entry and select the cell aboveShiftEnterShiftEnter
Cancel an entry in the cell or formula barEscEsc
Insert or edit a noteShiftF2ShiftF2
Enter the current dateCtrl;Ctrl;
Enter the current timeCmd;CtrlShift;
Switch between displaying cell values and displaying formulasCtrl`Ctrl`
Copy the formula from the cell above into the active cell or formula barCtrl'Ctrl'

All 24 in enter data and formulas · All 119 Excel shortcuts