Wednesday, April 25, 2007

yes, i'm an excel nerd

inevitably i spend the majority of my day in excel. but, it's not like i'm complaining because i happen to love excel. i mean it basically does all your work for you - that is if you know how to use it. me and my coworker go back and forth telling each other little short cuts we discover. we both have gotten to the point where there is no need for the mouse - we can do everything from the keyboard.

well, i almost never use the mouse. probably my favorite short cut is the alt-tab combination. especially since i'm the world's biggest multi-tasker so i always have about ten things open at the same time. but, here's what kills me - most of my spreadsheets have multiple sheets. and clearly they're all related so i'm bound to be going back and forth between the various sheets. but, as i tragically discovered, alt-tab doesn't do the trick between sheets. it totally screws with my rhythm when i have to go to the mouse to click the different tabs.

well, yesterday we figured it out. my coworker was on the phone with his friend who works up on the trading floor and was asking about something else when i yelled over to have him ask about this problem we'd been having. well, his friend came through in a big way. if you want to go between sheets all you have to do is hit ctrl and page up/down. go ahead and try it - you can thank me later.

the sun in shining, i'm going on a river cruise for lunch today and i'm going to charlottesville in two days. wow, life is great!

No comments: