Extend selection to last cell in worksheet
Windows shortcut
CtrlShiftEnd
Mac shortcut
Fn⌃⇧→
Extends the selection to the cell at the intersection of the last column (to the right) that contains data and the last row that contains data. The last cell in a worksheet may or may not contain data.
Related videos
The videos below demonstrate this shortcut.
In this lesson, we cover shortcuts you can use to extend selections.
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.