Oct 10 2008

Quickly Select Entire Sheet

I’ve talk to several people the last few days that weren’t aware of this simple trick.  Instead of using your mouse to select all the cells on your spreadsheet, Excel has a built-in way of quick selecting everything. 

By clicking in the top-left square, above the row numbers and left of the column letters, you can quickly select your currently active spreadsheet.  This can be useful if you want to select everything and copy it to another sheet, or if you want to quickly delete everything selected.  Check out the image below:

Select All Square in Red

** Excel Hints provides Excel Tips and Excel Help for All Levels.

Related Hints

Did you find this post helpful? Try signing up for our free daily tips.

Enter your email address: 

          

LEAVE A COMMENT

Subscribe Form

Subscribe to Blog

XLAutomation
Easily design MySQL databases as familiar spreadsheets in Micros
Get Expert Excel Help Today! 714.262.6893
Get Expert Excel Help Today! 714.262.6893

Categories

Excel Poll of the Week

How often do you use Excel macros (VBA)?

View Results

Loading ... Loading ...
<