To select all cells on a worksheet, do one of the following:
- Click the Select All button.
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+*.