Select the entire row in Excel
In Microsoft Excel, press Shift+Space 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: select
| Action | Mac | Windows |
|---|---|---|
| Select the entire worksheet | CmdA | CtrlA |
| Select the current region around the active cell | CtrlShift8 | CtrlShift8 |
| Select the entire column | CtrlSpace | CtrlSpace |
| Extend the selection by one cell | Shift→ | Shift→ |
| Extend the selection to the last nonblank cell in the same row or column | ShiftCmd→ | CtrlShift→ |
| Extend the selection to the beginning of the row | ShiftHome | ShiftHome |
| Extend the selection to the beginning of the worksheet | CtrlShiftHome | CtrlShiftHome |
| Extend the selection to the last used cell on the worksheet | CtrlShiftEnd | CtrlShiftEnd |
| Extend the selection down one screen | ShiftPageDown | ShiftPageDown |
| Turn extend mode on or off (use arrow keys to extend the selection) | F8 | F8 |