Select all cells on a worksheet

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

  • Click the Select All button.

    Select All button

  • Press CTRL+A.

    Note    If the worksheet contains data, and the active cell is above or to the right of the 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, press CTRL+SHIFT+*.

Applies To: Excel 2010

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language