1. Computing

Select All Cells in Excel

An Excel Keyboard Shortcut

By

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 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

  1. Open a blank Excel worksheet.

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

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

  4. All cells in the worksheet should be selected.

Example of How to Select All Cells in a Worksheet with Data

For help with this example, see the image to the right.

  1. Open a blank Excel worksheet.

  2. Enter the numbers 1 to 9 into cells D2 to F9.

  3. Click on any cell in the data area such as D2.

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

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

  6. All cells in the data area (D2 to F9) should be selected.

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

  8. All cells in the worksheet should be selected.

Other Keyboard Shortcuts

©2014 About.com. All rights reserved.