200 Excel Shortcuts for PC and Mac

Learn Microsoft Excel Download PDF

Select entire data range of the current selection

This selects the entire contiguous data range from your current selection. If this is not the entire worksheet, pressing this shortcut a second time will select the entire sheet. If your selection is within an Excel Table, Ctrl + A will select only the data portion of the table. A second time pressing Ctrl + A will include the header row, and a third will select the entire sheet.


Ctrl A

 A

Get more Excel tips and tricks

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