Extends the selection from the active cell to the last used cell on the sheet.

Windows

Ctrl + Shift + End

Mac

Fn + Ctrl + Shift + →

• Select all data

  Click A1, press Ctrl + Shift + End → A1 to the bottom-right used cell is selected

  The whole sheet's data.

• Skip headers

  Click B2, Ctrl + Shift + End → Everything from B2 to the end

  Skip the header row and first column.

• Clear to the end

  Ctrl + Shift + End, then Delete → Clears everything from the active cell onward

  A quick way to clear old content.

• Ctrl + Home first to start from the top.
• If the selection is far larger than the data, the used range is bloated; see Ctrl + End.
• Ctrl + Shift + ↓ then → is tighter when the data has no blanks.

• Includes formatted-but-empty cells at the end.
• In edit mode it selects text to the end of the entry.