will introduce you to the exciting new pivot table features in Excel 2007. Create quick summaries and pivot charts, add impact with traffic light icons, design calculated fields, group dates and numbers.
Excel Keyboard Shortcuts
"Microsoft Excel has no keyboard shortcut for “save as”. Probably because they are *only* on version 11."
That was one of the Twitters that I posted on Saturday. However, as Jason Morin pointed out in the comments, you can use the F12 key to open the Save As dialog box.
Why didn't the twitterer know that? Well, when you go to the Keyboard Shortcuts topic in Excel's Help, there's an incomplete list. It doesn't even show Ctl + S as a shortcut to Save, let alone tell us how to do a Save As.
To find a full list of Excel Keyboard shortcuts, you can download one of the following files or view the list on the web page.
Chip Pearson's site
View: Excel Keyboard Shortcuts list
Download: Excel Keyboard Shortcuts Excel file
Contextures site
View: Excel Keyboard Shortcuts list
Download: Excel Keyboard Shortcuts Excel file
Microsoft Excel Team Blog
Download: Excel Keyboard Shortcuts Excel file
In a blog post from Sept 2007, there's also a discussion of what keyboard shortcuts you'd like to see.
September 15th, 2008 at 11:44 am
Funny thing... I'm just working on a VBA course for a client, and one of the things I wanted to look up was a list of existing shortcuts so that the user wouldn't accidentally overwrite a useful one.
I knew of this unwieldy article: http://office.microsoft.com/en-ca/excel/HP052037811033.aspx
Great links!
September 15th, 2008 at 2:33 pm
Ken, glad it helped!
November 13th, 2008 at 1:00 am
Hi again!
I accidentally came to this site while reading some articles and I've found two interesting articles already. In fact, I have to work with MS Excel all the time. The company I'm working for loves it by some reasons. However, I'm not quite familiar with this application so when I wan to save I would go to File...Save... and when I want to do some other things, I would go to menu and find something there. I love the way you put them in groups. Make it easier for me to look up. Thanks!
January 8th, 2009 at 12:04 am
[...] few months ago, I mentioned some sites where you can download lists of Excel keyboard shortcuts. It’s even easier to get a list of Word keyboard shortcuts. There’s a built in macro that you [...]