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.
Download 200+ Excel Shortcuts
I work as a financial analyst and your page is a leading one I use to find so important info for daily tasks like formula explanation, how to construct different formulas and so on. This is brilliant! You helped me a lot. - Sarunas
