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

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!