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

Need more help?

Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.