Shortcut key to select entire worksheet (Ctrl + A)
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
Select a cell anywhere in the sheet where you want to select the entire sheet.
Press Ctrl + A to select the entire sheet.