Shortcut to get to bottom of Excel spreadsheet

• Release Jan 25, 2022Update Aug 24, 2022
• Written in Excel for Microsoft 365 version 2202

Normally, if you want to move to the bottom of the data, you must scroll manually to the end. However, when managing large data sets, it is inefficient to manually scroll to the bottom. The Excel shortcut we will show you allows you to get to the bottom of the data with a single keystroke. If you need to get to the bottom of a spreadsheet, please use these handy shortcuts to improve your work efficiency.

Shortcut to get to bottom of the spreadsheet

Get the bottom cell of the spreadsheet

Windows
Ctrl + End

Mac
With numeric keypad: control + end
Without numeric keypad: control + fn + → (Right Arrow key)

Get the bottom of current row

Windows
Ctrl + ↓ (Down Arrow key)

Mac
command + ↓ (Down Arrow key)

Get the bottom cell of the spreadsheet

This is a shortcut to get the bottom cell of the spreadsheet.

Total Time: 1 minute

Select a cell

Select any cell.

Get the bottom cell of the spreadsheet

Ctrl + End to get the bottom cell of the spreadsheet. This operation retrieves the cell at the intersection of the last column and row containing the data.

Get the bottom of current row

Select the cell in the column where you want to get the bottom.

Press Ctrl + ↓ (Down Arrow key) to get the bottom of the current column. This operation retrieves the bottom cell of contiguous data. If there is an empty cell in the middle of the data, it stops at the cell before it.