Excel 2003 Standard Toolbar Command | Excel 2010 Location and Command |
|---|---|
New | File tab, New, Blank Workbook |
Open | File tab, Open |
Save | Quick Access Toolbar, Save |
File tab, Save | |
Permission | Review tab, Changes group, Track Changes, Highlight Changes; then specify Who, When, and Where |
File tab, Save & Send, Send Using E-Mail | |
File tab, Print, Print | |
Print Preview | File tab, Print |
Spelling | Review tab, Proofing group, Spelling command |
Research | Review tab, Proofing group, Research command |
Cut | Home tab, Clipboard group, Cut command |
Copy | Home tab, Clipboard group, Copy command |
Paste | Home tab, Clipboard group, Paste command |
Format Painter | Home tab, Clipboard group, Format Painter command |
Undo | |
Redo | Quick Access Toolbar, Redo |
Ink Annotations | Review tab, Ink, Start Inking (Tablet PC only) |
Hyperlink | Insert tab, Links group, Hyperlink command |
AutoSum | Home tab, Editing group, AutoSum command |
Formulas tab, Function Library group, AutoSum command | |
Sort Ascending | Data tab, Sort & Filter group, Sort A To Z command |
Sort Descending | Data tab, Sort & Filter group, Sort Z To A command |
Chart Wizard | Insert tab, Charts group |
Drawing | These commands are available on the Drawing Tools tabs when you insert or select a shape. |
Zoom | View tab, Zoom group, Zoom command |
Microsoft Excel Help | Upper ribbon, Help |
PivotTable And PivotChart Report | Insert tab, Tables group, PivotTable command, PivotTable or PivotChart command |
Comment | Review tab, Comments group, New Comment command |
AutoFilter | This functionality is now added when you create a table. Otherwise, you must add a button to the ribbon or the Quick Access Toolbar for this command: File tab, Options, Customize Ribbon or Quick Access Toolbar, All Commands, AutoFilter |