Add missing built-in commands to the QAT or Ribbon
Many Excel 2007 commands do not appear anywhere in the Ribbon, including
some that used to be on the menus in Excel 2003. These commands still exist
but you have to do something to make them available.
Examples of commands not in the Ribbon
There are two ways you can make these commands and many others available.
Add missing commands to the QAT
You can add useful commands to your QAT like this:
Right click on the QAT and choose Customize Quick Access Toolbar.

In the “Choose commands from” dropdown choose "Commands Not in the Ribbon".
Then select the command you want in this long list and press “Add”

Note: In the “Customize Quick Access Toolbar” dropdown choose “For <workbook name>”
if you want to add the commands only to the ActiveWorkbook.
More information about the QAT you can find on this page:
Add buttons to the QAT and customize the images of the buttons
http://www.rondebruin.nl/imageqat.htm
Add missing commands to your own custom Ribbon tab
If you want to know the RibbonX of Built-in commands that are in the Ribbon see this page.
http://www.rondebruin.nl/xmlribbongroups.htm
But if you want to add missing commands to your own custom Ribbon tab you
must know the RibbonX for the command that you want to add to the Ribbon.
The idMso of the command you can find like this, point to the command in the
"Commands Not in the Ribbon" list with your mouse and you see this.

Now we download a file on this page(point 3)
http://www.rondebruin.nl/ribbon.htm
We search for the idMso of the command that you want to add to the Ribbon in this file.
You will find the Type of the command (button, toggleButton or ?) on the same row in this file.
Now we have enough information to create this line to add the command.
<toggleButton idMso="SendCopySendToMailRecipient" size="normal"/>
Ribbon Example
The RibbonX below will create a new tab on the Ribbon with a few example commands.
You can save the workbook with the RibbonX below as a add-in if you want to use the
commands in all your workbooks.
Note: If you not know how to add RibbonX to your workbook check out this page
http://www.rondebruin.nl/ribbon.htm

More information
Change the Ribbon in Excel 2007
http://www.rondebruin.nl/ribbon.htm
There are more links in the "More Information" part of that page
Examples of commands not in the Ribbon
| Name in the "Commands Not in the Ribbon" list |
| Send to Mail Recipient |
| Camera |
| Add-ins |
| Select Visible Cells |
| Select Current Region |
| Form |
| Speak Cells by Columns |
| Speak Cells by Rows |
| Speak Cells on Enter |
| Speak Cells |
| Speak Cells - Stop Speaking Cells |
| Print Table |
There are two ways you can make these commands and many others available.
Add missing commands to the QAT
You can add useful commands to your QAT like this:
Right click on the QAT and choose Customize Quick Access Toolbar.

In the “Choose commands from” dropdown choose "Commands Not in the Ribbon".
Then select the command you want in this long list and press “Add”

Note: In the “Customize Quick Access Toolbar” dropdown choose “For <workbook name>”
if you want to add the commands only to the ActiveWorkbook.
More information about the QAT you can find on this page:
Add buttons to the QAT and customize the images of the buttons
http://www.rondebruin.nl/imageqat.htm
Add missing commands to your own custom Ribbon tab
If you want to know the RibbonX of Built-in commands that are in the Ribbon see this page.
http://www.rondebruin.nl/xmlribbongroups.htm
But if you want to add missing commands to your own custom Ribbon tab you
must know the RibbonX for the command that you want to add to the Ribbon.
The idMso of the command you can find like this, point to the command in the
"Commands Not in the Ribbon" list with your mouse and you see this.

Now we download a file on this page(point 3)
http://www.rondebruin.nl/ribbon.htm
We search for the idMso of the command that you want to add to the Ribbon in this file.
You will find the Type of the command (button, toggleButton or ?) on the same row in this file.
Now we have enough information to create this line to add the command.
<toggleButton idMso="SendCopySendToMailRecipient" size="normal"/>
Ribbon Example
The RibbonX below will create a new tab on the Ribbon with a few example commands.
You can save the workbook with the RibbonX below as a add-in if you want to use the
commands in all your workbooks.
Note: If you not know how to add RibbonX to your workbook check out this page
http://www.rondebruin.nl/ribbon.htm

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon>
<tabs>
<tab id="CustomTab" label="Not in the Ribbon Tab" insertAfterMso="TabHome">
<group id="YourCustomGroup1" label="Div Commands">
<toggleButton idMso="SendCopySendToMailRecipient" size="normal"/>
<button idMso="Camera" size="normal"/>
<button idMso="AddInManager" size="normal"/>
<button idMso="TableSelectVisibleCells" size="normal"/>
<button idMso="SelectCurrentRegion" size="normal"/>
<button idMso="DataFormExcel" size="normal"/>
</group>
<group id="YourCustomGroup2" label="Speak Commands">
<toggleButton idMso="SpeakByColumns" size="normal"/>
<toggleButton idMso="SpeakByRows" size="normal"/>
<toggleButton idMso="SpeakOnEnter" size="normal"/>
<button idMso="SpeakCells" size="large"/>
<button idMso="SpeakStop" size="large"/>
</group>
<group id="YourCustomGroup3" label="Print">
<button idMso="PrintListRange" size="large"/>
</group>
</tab>
</tabs>
</ribbon>
</customUI>
More information
Change the Ribbon in Excel 2007
http://www.rondebruin.nl/ribbon.htm
There are more links in the "More Information" part of that page