Windows Mac
CtrlA A

About This Shortcut 

This shortcut will select the entire worksheet. The behavior changes on subsequent use If the cursor is inside a region with adjacent, non-empty cells:

  1. First time - will select the region that contains non-empty cells
  2. Second time - will select the entire worksheet

Related videos

The videos below demonstrate this shortcut.

Dave Bruns Profile Picture

AuthorMicrosoft Most Valuable Professional Award

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.