Microsoft Excel 2007 - Select All with One Click

There are several ways to select an entire worksheet:

1. Click on the little gray box in the top-left corner of the worksheet.
2. Press CTRL+A

This is very useful when you need to apply formatting to all cells or to copy an entire worksheet.