You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
Today's blog post on keyboard shortcut reference cards is brought to you by Office.com writer, Turi Henderson. Turi has been on the Office.com team for a few years, writing mainly about Accessibility features and Language Tools, and periodically plying her coworkers with fine baked goods.
You use them every day to make your work flow smoothly, or - in some cases - to make your work flow, period. In all honesty, I use some of them so often that I have no idea where to find those functions on the ribbon! (Copy? Paste? Undo? I haven't done those with a mouse in YEARS!) And I know I'm not alone. In the content that I manage, it is THE most popular subject, and generates the most feedback, with Excel users leading the charge.
There's already a lovely article that talks about keyboard shortcuts in Excel 2010. It's a fantastic resource, and has a lot of great information on what you can do just using your keyboard, but it's quite long. It's a lot of great information to scroll through to find what you need. So, in response to an overwhelming number of requests from you, Excel users, I've created some Quick Reference Cards - sheets, really - that you can download and save, or just print and keep near your workstation.
Keyboard shortcuts - Ctrl keys
Keyboard shortcuts - Function keys
Keyboard shortcuts - Miscellaneous
They look like this:
You can also find them in the aforementioned lovely article, off to the side of each keyboard shortcut section:
Click the link, and the sheet will open as a PDF for you to save or print. They're all two pages or fewer, so you can print double-sided onto a single sheet, if you like.
The plan is to have these for all Office products, eventually, but we'd love to know what you think about this first set before we do that. Are these helpful? How's the formatting? Does it cover what you need? Let us know in the comments here, or through the article feedback!
People have been asking for such a card for a long time. Thanks for giving the people what they want, Turi!
In addition, check out these earlier posts:
Part 1: Excel team favorite shortcuts - http://bit.ly/lwhwMb
Part 2: Excel team favorite shortcuts - http://bit.ly/r5VxDI
Part 3: Excel team favorite shortcuts - http://bit.ly/pwcLi2
Love live F4.
Die Maschinenübersetzung ist wirklich nicht brauchbar / The machine translation is just terrible
Looks good, but what about F4 - absolute reference - serious omission!
Thank you for the wonderful post... I will sure make a mention on my offcial tech blog at www.explorefeed.com
Thank you for the wonderful post... I will sure make a mention on my offcial tech blog at - http://www.explorefeed.com
Thanks Tim! Looks like that one was overlooked - we'll get the article and downloadables updated ASAP.
Thanks for the shout out, Explorefeed!
These reference cards are great... and timely. I was searching around to confirm that CTRL+SHIFT+N was not a built-in shortcut, but rather custom code inside one of my client's black-boxed add-ins. Your reference cards made this easy. Thanks.
Let me guess: you prepared first the Ctrl key ones and then the rest? Am I right? What do I win? No, seriously, there is an error in the title of the second page of the Fn keys one.
Good catch Biofaust - we'll clean that up.
I just joined and I am just learning Excel so I do like the shortcut keys, Thanks
Well I like the above posts. thanks for giving information. Anyways, I am going to write an article on above subject. Guys, can check my "Official Technology Blog": http://www.explorefeed.com Don't miss it!
Has CTRL + SHIFT + ) been removed now to hide columns? No longer seems to work and isn't listed, though CTRL + SHIFT + ( still hides a row. Thanks
Hi Jennifer -- That's a known bug, unfortunately.
I have my top favorites when it comes to shortcuts. They save time incredibly. I think there is a direct correlation between time spent working in Excel and the number of keywords you know and can use proficiently. With time, it really gets annoying to move your hands from the keyboard to mouse and back. You can check my top picks here (I'm not going to copy the whole blog post, but I thought it's worth sharing): www.exceleverest.com/.../My-top-5-keyboard-shortcuts-in-Microsoft-Excel.aspx
The shortcuts are a real blessing, and you should really know as many as possible. Adding them to the daily routine while working with Excel is saving me tons and tons of time.
The collection of shortcut keys is much appreciated.
At the same time, the organization of the list reflects the "Engineer" mentality so seemingly prevalent at Microsoft rather than a"user-focused" orientation. Most of the list is arranged by keystroke combination, i.e., here are all the nifty things you can do while holding down the Ctrl key, etc.
My understanding is that the whole point of the Ribbon interface was to (finally) organize application commands as users might encounter them--by specific spreadsheet workflow task, e.g., what commands are related to charts, or formulas, or databases, etc.
With that in mind...how about providing a list of shortcuts for users that is similarly organized, by task, i.e., here are all the shortcuts related to creating and formatting charts, or all the shortcuts related to navigating and selecting cells, etc.?
Now THAT would be even more helpful.