"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.
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! :)
Ken, glad it helped!
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!
[...] 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 [...]
Hi Debra,
I compiled a list of the Alt activated shortcuts with a bief explanation of each.
The list is complimentary to the ones posted above.
http://finaticsonline.com/blog/2011/01/keyboard-accelerators-and-shortcut-keys-in-ms-excel-2010/
--
The Finatics Blog