Alex Campbell
asked on
Looking for a list of Excel 2016 Commands by Menu
I am looking for a list of Excel 2016 commands. While there is the "what do you want to do?" spot on the menu, it doesn't help find where the command is.
I have seen lists for Excel 2003 to Excel 2007, but 2016 appears to me to be different enough that I don't find some of the commands.
I have seen lists for Excel 2003 to Excel 2007, but 2016 appears to me to be different enough that I don't find some of the commands.
What menu do you mean? Most commands are on the Ribbon. There's a right click menu
I don't understand your last post
ASKER
The situation that brought up this question is that I wanted to create a custom list.
I found a spreadsheet at Microsoft that was to help people moving to Excel 2007 from 2003.
However, it didn't list Custom List. And, if I go to Tell me what you want to do, or Help, they don't cover it.
I was able to find that Custom List under Data, Sort, Order. That's why I am looking for a complete list of commands.
I found a spreadsheet at Microsoft that was to help people moving to Excel 2007 from 2003.
However, it didn't list Custom List. And, if I go to Tell me what you want to do, or Help, they don't cover it.
I was able to find that Custom List under Data, Sort, Order. That's why I am looking for a complete list of commands.
I see what you mean. I haven't seen one myself but I'll see what I can find
ASKER
Thanks, I appreciate it.
ASKER
Thanks, that would help if there was a way to capture the text. I tried it with Snagit screen capture, but they say that Windows 7 has made it very hard to do things like that.
I've posted a screen capture but I don't think you can extract the text.
ASKER
For what it's worth, I was able to collect all the commands by using a screen capture into PDF files and then OCR'ing the PDF files and editing them. Here is the list. I have contacted Microsoft in trying to get a list of the menu commands to use these.
Excel2016-AllCommands.xlsx
Excel2016-AllCommands.xlsx
Did you get this list from Excel Options as a source?
ASKER
There are two ways to get there, but yes:
1) Right click on the Quick Access Toolbar, Choose More Commands
2) File, Options, Quick Access Toolbar
and
Under "Choose commands from:"
Select "All"
1) Right click on the Quick Access Toolbar, Choose More Commands
2) File, Options, Quick Access Toolbar
and
Under "Choose commands from:"
Select "All"
Yes that's a short cut to the Options Form that I used. What software did you use to extract the list from the screen shot?
ASKER
I used Snagit to select part of the screen to save the commands to a PDF file.
Avoid the icons for the commands. If they are included in the screen capture, the OCR puts in garbage characters.
Use Adobe Acrobat Pro or some other program to do the OCR.
In Acrobat, you would choose View, Tools, Recognize Text, In This File.
Then, choose Edit, Select All.
Edit, Copy.
Open a text editor or word processor and then paste.
Avoid the icons for the commands. If they are included in the screen capture, the OCR puts in garbage characters.
Use Adobe Acrobat Pro or some other program to do the OCR.
In Acrobat, you would choose View, Tools, Recognize Text, In This File.
Then, choose Edit, Select All.
Edit, Copy.
Open a text editor or word processor and then paste.
I use Able2Extract but not tried it on a screen shot. I'll have a play when I get time
ASKER
Here are links to menu commands and shortcuts.
I have also uploaded a file with lots of them.
Description # URL
Excel 2007 Shortcut Database 453 http://www.veodin.com/keyrocket/excel-2007-shortcuts/
Excel 2010 Shortcut Database 507 http://www.veodin.com/keyrocket/excel-2010-shortcuts/
Excel 2013 Shortcut Database 589 http://www.veodin.com/keyrocket/excel-2013-shortcuts/
Outlook 2007 Shortcut Database 172 http://www.veodin.com/keyrocket/outlook-2007-shortcuts/
Outlook 2010 Shortcut Database 383 http://www.veodin.com/keyrocket/outlook-2010-shortcuts/
Outlook 2013 Shortcut Database 276 http://www.veodin.com/keyrocket/outlook-2013-shortcuts/
Powerpoint 2007 Shortcut Database 273 http://www.veodin.com/keyrocket/powerpoint-2007-shortcuts/
Powerpoint 2010 Shortcut Database 332 http://www.veodin.com/keyrocket/powerpoint-2010-shortcuts/
Powerpoint 2013 Shortcut Database 379 http://www.veodin.com/keyrocket/powerpoint-2013-shortcuts/
Windows 7 Explorer Shortcut Database 60 http://www.veodin.com/keyrocket/windows-shortcuts/windows-7-explorer-shortcuts/
Windows 8 Explorer Shortcut Database 87 http://www.veodin.com/keyrocket/windows-shortcuts/windows-8-explorer-shortcuts/
Windows Vista Explorer Shortcut Database 60 http://www.veodin.com/keyrocket/windows-shortcuts/windows-vista-explorer-shortcuts/
Windows XP Explorer Shortcut Database 60 http://www.veodin.com/keyrocket/windows-shortcuts/windows-xp-explorer-shortcuts/
Word 2007 Shortcut Database 548 http://www.veodin.com/keyrocket/word-2007-shortcuts/
Word 2010 Shortcut Database 581 http://www.veodin.com/keyrocket/word-2010-shortcuts/
Word 2013 Shortcut Database 298 http://www.veodin.com/keyrocket/word-2013-shortcuts/
I have also uploaded a file with lots of them.
Description # URL
Excel 2007 Shortcut Database 453 http://www.veodin.com/keyrocket/excel-2007-shortcuts/
Excel 2010 Shortcut Database 507 http://www.veodin.com/keyrocket/excel-2010-shortcuts/
Excel 2013 Shortcut Database 589 http://www.veodin.com/keyrocket/excel-2013-shortcuts/
Outlook 2007 Shortcut Database 172 http://www.veodin.com/keyrocket/outlook-2007-shortcuts/
Outlook 2010 Shortcut Database 383 http://www.veodin.com/keyrocket/outlook-2010-shortcuts/
Outlook 2013 Shortcut Database 276 http://www.veodin.com/keyrocket/outlook-2013-shortcuts/
Powerpoint 2007 Shortcut Database 273 http://www.veodin.com/keyrocket/powerpoint-2007-shortcuts/
Powerpoint 2010 Shortcut Database 332 http://www.veodin.com/keyrocket/powerpoint-2010-shortcuts/
Powerpoint 2013 Shortcut Database 379 http://www.veodin.com/keyrocket/powerpoint-2013-shortcuts/
Windows 7 Explorer Shortcut Database 60 http://www.veodin.com/keyrocket/windows-shortcuts/windows-7-explorer-shortcuts/
Windows 8 Explorer Shortcut Database 87 http://www.veodin.com/keyrocket/windows-shortcuts/windows-8-explorer-shortcuts/
Windows Vista Explorer Shortcut Database 60 http://www.veodin.com/keyrocket/windows-shortcuts/windows-vista-explorer-shortcuts/
Windows XP Explorer Shortcut Database 60 http://www.veodin.com/keyrocket/windows-shortcuts/windows-xp-explorer-shortcuts/
Word 2007 Shortcut Database 548 http://www.veodin.com/keyrocket/word-2007-shortcuts/
Word 2010 Shortcut Database 581 http://www.veodin.com/keyrocket/word-2010-shortcuts/
Word 2013 Shortcut Database 298 http://www.veodin.com/keyrocket/word-2013-shortcuts/
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Found information on website.