Select to data edge: the shortcut in both apps
Each app binds this differently. The table shows the keys in Google Sheets and Excel side by side.
| App | Mac | Windows | Linux |
|---|---|---|---|
| Google SheetsExtend the selection to the data edge | ShiftCmd↓ | CtrlShift↓ | CtrlShift↓ |
| ExcelExtend the selection to the last nonblank cell in the same row or column | ShiftCmd→ | CtrlShift→ | — |
How the apps compare
- Mac: Cmd+Shift+↓ in Google Sheets; Cmd+Shift+→ in Excel.
- Windows: Ctrl+Shift+↓ in Google Sheets; Ctrl+Shift+→ in Excel.
- Linux: Ctrl+Shift+↓ in Google Sheets.
Where and when it works
- Excel: Works with any arrow key. Press twice to continue past a blank cell.
Learn it by pressing it: Google Sheets shortcuts practice or Excel shortcuts practice.