Excel Hack

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

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

The current area is selected

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

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 and press Ctrl +A

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

Select entire sheet

Press Ctrl + A to select the entire sheet.

Comments

Please send us your comments on this article.

0 comments
Inline Feedbacks
View all comments