Crabby's shorty shortcut tips for working smarter (Part I)

I love finding ways to get my work done quicker so that I can push myself away from my desk, take a deep stretch, and ponder the many avenues I have taken on my way to Crabbydom.

What about you? What would YOU be doing if you weren't chained to your desk? How about you learn some new tricks first and figure that out later.

In this week’s column, I offer three tips for three programs: Word, Outlook and Excel; in a couple of weeks I’ll cover three more. Here are some examples of my personal tips:

  • Did you know that you can create your very own keyboard shortcuts? In Word, click the Office button and then click Word Options. Click Customize on the left, and then click Customize next to Keyboard Shortcuts.

    This opens the Customize Keyboard dialog box, where you can choose the categories and commands you want and assign keyboard shortcuts.
  • When you need to resend a message, do you forward it? Or hit Reply All and send it off again (sending you a copy as well)? If so, you’re working way too hard. Open up the message, click Other Actions, and then click Resend This Message.
  • To work well in Excel you must think like Excel…be Excel. When toggling between multiple worksheets in a workbook you can always use your mouse or even the keyboard shortcuts. But what if you want to see a list of ALL the worksheets in that workbook?

    Tab navigation buttons  Right-click one of the tab navigation buttons…

List of worksheets

 

 

... and a floating list of all the worksheets in the workbook will appear. Just click the one you want.

Want more of Crabby’s shorty shortcuts? Read the entire column on Office Online.

Crabby Office Lady

— Crabby

Listen and subscribe to Crabby’s podcasts

Office Blogs Comments

Comments: (2) Collapse

  • OK, I already knew how to add personalized shortcuts in Word. Is there any way of doing it in Excel? I've looked, but haven't recognized it if it is there. I know it can be done for macros, but how about Ribbon commands.

  • Hi Ron -- I don't belive one can customize keyboard shortcuts in Excel 2007. I poked around in there and the Keyboard Shortcuts area in the customization dialog does NOT have a "Customize" button like it does in Word. Sorry about that!

Comments

Comments: (loading) Collapse