Shortcut to get to bottom of Excel spreadsheet
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.