Define a name for the selection in Excel
In Microsoft Excel, press Ctrl+F3 on Mac, Windows.
EscF1F2F3F4F5F6F7F8F9F10F11F12PrtScScrLkPause
`1234567890-=deleteInsHomePgUp
TabQWERTYUIOP[]\DelEndPgDn
CapsASDFGHJKL;'return
ShiftZXCVBNM,./Shift↑
fnctrloptcmdcmdopt←↓→
EscF1F2F3F4F5F6F7F8F9F10F11F12PrtScScrLkPause
`1234567890-=BkspInsHomePgUp
TabQWERTYUIOP[]\DelEndPgDn
CapsASDFGHJKL;'Enter
ShiftZXCVBNM,./Shift↑
CtrlWinAltAltWinMenuCtrl←↓→
See it happen Press the shortcut above, or
More Excel shortcuts: enter data and formulas
| Action | Mac | Windows |
|---|---|---|
| Edit the active cell and put the insertion point at the end of its contents | CtrlUorF2 | F2 |
| Start a new line in the same cell | CtrlOptionEnterorOptionCmdEnter | AltEnter |
| Fill the selected cell range with the current entry | CtrlEnter | CtrlEnter |
| Complete a cell entry and select the cell above | ShiftEnter | ShiftEnter |
| Cancel an entry in the cell or formula bar | Esc | Esc |
| Insert or edit a note | ShiftF2 | ShiftF2 |
| Enter the current date | Ctrl; | Ctrl; |
| Enter the current time | Cmd; | CtrlShift; |
| Switch between displaying cell values and displaying formulas | Ctrl` | Ctrl` |
| Copy the formula from the cell above into the active cell or formula bar | Ctrl' | Ctrl' |