Skip to content

↑↓ moveEnter openEsc close

Select to data edge: the shortcut in both apps

2 apps · Mac, Windows and Linux

Each app binds this differently. The table shows the keys in Google Sheets and Excel side by side.

AppMacWindowsLinux
Google SheetsExtend the selection to the data edgeShiftCmd↓CtrlShift↓CtrlShift↓
ExcelExtend the selection to the last nonblank cell in the same row or columnShiftCmd→CtrlShift→—

Small screen: your system's keys only. Open an app's row for every system.

A dash means the app has no default binding, or does not run, on that system. Open a row for notes and the full key details.

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.