Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Select all cells on a worksheet
 

To select all cells on a worksheet, do one of the following:

  • Click the Select All button.

    Select All button

  • Press CTRL+A.

    Note   If the worksheet contains data, pressing CTRL+A selects the current region. Pressing CTRL+A a second time selects the entire worksheet.

Tip   If you want to select all cells in the active range (range: Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.), press CTRL+SHIFT+*.

© 2009 Microsoft Corporation. All rights reserved.