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+*.

Was this information helpful?

How can we improve it?

How can we improve it?

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

Thank you for your feedback!