This Excel tip covers how to select all cells in an Excel worksheet using a keyboard shortcut. Doing so allows you to apply changes such as formatting, column width, etc. to a worksheet all at once.
Related article: Select All Cells in an Excel Data Table.
Example of How to Select All Cells in a Blank Worksheet
- Open a blank Excel worksheet.
- Press and hold down the Ctrl key on the keyboard.
- Press and release the letter " A " key on the keyboard without releasing the Ctrl key.
- All cells in the worksheet should be selected.
Example of How to Select All Cells in a Worksheet with Data
Note: For help with this example, see the image to the right.
- Open a blank Excel worksheet.
- Enter the numbers 1 to 9 into cells D2 to F9.
- Click on any cell in the data area such as D2.
- Press and hold down the Ctrl key on the keyboard.
- Press and release the letter " A " key on the keyboard without releasing the Ctrl key.
- All cells in the data area (D2 to F9) should be selected.
- Press and release the letter " A " a second time.
- All cells in the worksheet should be selected.
Other Keyboard Shortcuts
