Selecting the entire worksheet in Excel 2007

You can select the entire worksheet by clicking the grey box that is to the left of the Column heading A.

Alternative ways to select the entire worksheet:

• Press CTRL + A to select the entire worksheet.
• Press CTRL + SHIFT + SPACEBAR to select the entire worksheet.

In the alternative ways provided above, if you attempt to key in CTRL + A or CTRL + SHIFT + SPACEBAR in a region then only the cells in the region get selected. Press CTRL + A or CTRL + SHIFT + SPACEBAR again to select the entire worksheet.

You may also try this. Click cell A1 and press the CTRL + SHIFT + RIGHT arrow keys and CTRL + SHIFT + DOWN arrow keys to select the entire worksheet.