200 Excel Shortcuts for PC and Mac

Learn Microsoft Excel Download PDF

Extend current selection to the bottom edge of data

This shortcut follows the same concept of extending your selection, but does so on a larger scale. Use this shortcut when you have a data-filled cell selected and you will instantly select all filled cells below. If the cell you are working on is empty, all blank cells to the end of the spreadsheet will be selected.


Ctrl Shift 

Control Shift 

Get more Reference tips and tricks

Subscribe to our email updates and get Reference tips direct to your inbox.