This Excel tip covers how to select all cells in an Excel data table 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: Creating a Data Table in Excel .
Note: For help with this example, see the image to the right.
Example of How to Select All Cells in a Data Table
- Open an Excel worksheet containing a data table or create a data table .
- Click on any cell in the data table.
- 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 table should be highlighted.
- Press and release the letter " A " a second time.
- The heading row of the data table should be highlighted as well as the data table.
- Press and release the letter " A " a third time.
- All cells in the worksheet should be highlighted.
Other Keyboard Shortcuts