Shortcut key to select entire worksheet (Ctrl + A)

Release Jan 25, 2022Update Aug 24, 2022
Written in Excel for Microsoft 365 version 2202

Learn how to use a shortcut on a worksheet to select all cells. If you want to change the font of the entire worksheet, or if you want to copy and paste the entire sheet to another location, you can use this shortcut key to select all the cell. Here are the shortcuts available for Windows and Mac.

Select entire worksheet shortcut

Windows
Ctrl + A

Mac
command + A or control + A

If the data is on a worksheet

If you want to select the entire sheet with data using a shortcut key, please use the following method.

Total Time: 1 minute

Select a cell

Select a cell anywhere in the sheet where you want to select the entire sheet.

The current area is selected

Press Ctrl + A to select the current area. If the worksheet contains data and the active cell is above or to the right of the data, the current area will be selected.

The entire sheet can be selected

Press Ctrl + A again to select the entire sheet.

If there is no data on the worksheet