Exceljet

Quick, clean, and to the point

Select entire worksheet

Windows shortcut 
CtrlA
Mac shortcut 
A

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.
In this video we show you some of Excel's shortcuts for selecting cells.
In this lesson, we cover shortcuts you can use to select cells.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.

Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas