In this section:

Where are my toolbars?
I don't see the print button!
What if I like the old school dialog boxes?
Holy Guacamole, where is the AutoSum button?
Where do I find Format Cells?
Where is the Chart Wizard?
Where are these common tools?


Where are my toolbars?
Excel 2010 no longer uses the default Menu, Standard, or Formatting toolbars.Instead you have what are called “Ribbons.”These ribbons house many of the commands that we once relegated to dialog boxes and different option settings.It may take some time to get use to, but you will find that the ribbons seem somewhat familiar to the old Menu Toolbar.Any ribbon can be customized to your liking.All you must do is right click the ribbon and click “Customize Ribbon.”
Back to Top

I don’t see the print button!
Click the “File” button.This opens the “Backstage” view.Click “Print.”Instead of opening a dialog box like in Excel 2003, the Backstage view changes according to the menu you select.You should see all the same options you would have seen in the dialog box in the Backstage view.

A Print button can be added to your Quick Access toolbar.To do so, click the drop-down menu on your Quick Access toolbar and select “Print Preview and Print.”It is not recommended to use “Quick Print” since it will print to whatever the default printer is set to at the time.
Back to Top

What if I like the old school dialog boxes?
On the ribbon for each section there is a button you can click that brings up the familier dialog boxes.It is in the buttom right corner of each section.
Back to Top

Holy Guacamole, where is the AutoSum button?
It is now located in the Formulas ribbon.While there you will notice the “Insert Function” button and some new function buttons.You can also find it in the “Home” ribbon in the “Editing” section.
Back to Top

Where do I find Format Cells?
You have two options here, highlight and right click the cells.You will find Format Cells in the menu and it looks exactly like the old 2003 dialog box.

Option 2: All the options that were in the Format Cells dialog box are now in the Home ribbon.You can find a drop-down menu to select the number formatting.In that drop-down you will also see an option to open the dialog box.
Back to Top

Where is the Chart Wizard?
The Chart Wizard does not exist anymore.Instead, you insert a chart view the “Insert” ribbon.Once the chart is inserted you can click it.This brings up the temporary “Chart Tools” ribbon collection.The “Design” ribbon has most of the previous chart wizard functions.
Back to Top

Where are these common tools?

  • Chart Wizard – Insert Ribbon
  • Clipart/AutoShapes – Insert Ribbon
  • Copy – Home Ribbon – keyboard shortcut Ctrl+C
  • Cut – Home Ribbon – keyboard shortcut Ctrl+X
  • Header/Footer – Insert Ribbon
  • Increase & Decrease Buttons – Home Ribbon
  • Insert/Delete Rows or Columns – Home Ribbon
  • Merge & Center – Home Ribbon – Also houses Unmerge
  • Open – File Button – keyboard shortcut Ctrl+O
  • Paste – Home Ribbon – keyboard shortcut Ctrl+V
  • Portrait/Landscape – Page Layout Ribbon
  • Print – File Button – keyboard shortcut Ctrl+P
  • Save – Quick Access Toolbar – Top of screen, keyboard shortcut Ctrl+S
  • Save As – File Button
  • Zoom – View Ribbon
Back to Top