Thursday, March 25, 2010

Three Cool Tricks!




Here are three of my favorite little tricks for making life easier in Excel World…




#1 Selecting Data or the Entire Worksheet
Select any cell in your database and click “A” on your keyboard while holding down the Ctrl key; Bamm! You have selected the database. Want to select the entire worksheet? Just click “A” once again!

#2 Copy the Formatting of a Cell or Range and Apply it to Another Cell or Range
Select the cell or range with the formatting you wish to copy, (Note: This works for conditional formatting as well), and click the Paint Brush on your toolbar. Your cursor will then turn into a paint brush that you can use to “paint” any other cell or range with the formatting you have picked up from the previous cell or range (think of them as the paint can).

#3 Display Formulas So You can Troubleshoot Issues
This is so easy, you will laugh. Select any cell on cell on your worksheet and simply press the “~” key on your keyboard while holding down the Ctrl key. Presto! All of your formulas will be visible!

How cool is that! Take five minutes and give the tricks a try!

No comments: