1. Computing

Discuss in my forum

Select All Cells in an Excel Data Table

An Excel Keyboard Shortcut

By , About.com Guide

Select Cells Using a Keyboard Shortcut

Select Cells Using a Keyboard Shortcut

© Ted French

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

  1. Open an Excel worksheet containing a data table or create a data table .

  2. Click on any cell in the data table.

  3. Press and hold down the Ctrl key on the keyboard.

  4. Press and release the letter " A " key on the keyboard without releasing the Ctrl key.

  5. All cells in the data table should be highlighted.

  6. Press and release the letter " A " a second time.

  7. The heading row of the data table should be highlighted as well as the data table.

  8. Press and release the letter " A " a third time.

  9. All cells in the worksheet should be highlighted.

Other Keyboard Shortcuts

©2013 About.com. All rights reserved.