Solved

Looking for a list of Excel 2016 Commands by Menu

Posted on 2016-07-27
18
34 Views
Last Modified: 2016-09-04
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.
0
Comment
Question by:Alex972
  • 10
  • 8
18 Comments
 
LVL 17

Expert Comment

by:Roy_Cox
ID: 41733431
What menu do you mean? Most commands are on the Ribbon. There's a right click menu
0
 

Author Comment

by:Alex972
ID: 41733602
Menu for Excel 2016
0
 
LVL 17

Expert Comment

by:Roy_Cox
ID: 41734171
I don't understand your last post
0
 

Author Comment

by:Alex972
ID: 41734844
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.


Search for Custom List in 2007 Command List
Create Custom List from Tell me...
Help for Create Custom List
Custom List from Sort Order.
0
 
LVL 17

Expert Comment

by:Roy_Cox
ID: 41734885
I see what you mean. I haven't seen one myself but I'll see what I can find
0
 

Author Comment

by:Alex972
ID: 41734893
Thanks, I appreciate it.
0
 
LVL 17

Expert Comment

by:Roy_Cox
ID: 41754177
If you go to File -> Excel Options then Customize the Ribbon you can Lists of Commands. maybe this will help.Customize Ribbon All Commands
0
 

Author Comment

by:Alex972
ID: 41754242
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.
0
 
LVL 17

Expert Comment

by:Roy_Cox
ID: 41754579
I've posted a screen capture but I don't think you can extract the text.
0
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 

Author Comment

by:Alex972
ID: 41758332
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
0
 
LVL 17

Expert Comment

by:Roy_Cox
ID: 41758882
Did you get this list from Excel Options as a source?
0
 

Author Comment

by:Alex972
ID: 41759278
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"
0
 
LVL 17

Expert Comment

by:Roy_Cox
ID: 41759793
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?
0
 

Author Comment

by:Alex972
ID: 41761077
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.
0
 
LVL 17

Expert Comment

by:Roy_Cox
ID: 41761261
I use Able2Extract but not tried it on a screen shot. I'll have a play when I get time
0
 

Author Comment

by:Alex972
ID: 41777416
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/
0
 

Accepted Solution

by:
Alex972 earned 0 total points
ID: 41777417
File from previous comment is now uploaded and attached.
CombinedMenus-Shortcuts.xls.xlsx
0
 

Author Closing Comment

by:Alex972
ID: 41783514
Found information on website.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now