Thursday, June 3, 2010

Save Your Wrist (And Look Cool Doing It…)

Yesterday while breezing through an Excel workbook and entering some repetitive data, I realized I have never mentioned a couple of my favorite Gee Whiz tricks. They not only have Wow Factor, they are also very practical and Ergonomic!

Any time you can use your keyboard and avoid your mouse, you are probably doing your wrist a favor. There is typically much less stress using the keyboard.

Elegant Navigation
Rather than using a mouse to navigate to another worksheet within an Excel workbook, you can simply use CTRL+PAGE DOWN to move one worksheet to the right or CTRL+PAGE UP to move one worksheet to the left. Not only is it efficient, but you will Look Cool doing it!

Enter in Bulk
Let’s say you want to enter the same numbers or same text in a block of cells. There are a number of inelegant ways of doing this, but if you want to save your wrist and be Totally Cool in the process, you can do the following:

1. Select the entire range of cells you want to contain the same content
2. Type your words or values (be sure to do this while having the entire block of cells selected)
3. Press CTRL+ENTER

Presto! You are a Genius! Go ahead, give it a try!


2 comments:

Anonymous said...

這麼優的部落格一定要持續下去! ..................................................

Anonymous said...

Birth is much but breeding is more. 加油! ....................................................