Appendix A: Menu to Ribbon Command Reference
Overview
This appendix lists the menu commands and major toolbar buttons from Microsoft Excel 2003 and shows you where to find the equivalent functionality in Microsoft Office Excel 2007. In most cases, Microsoft has relocated commands on the new Ribbon structure. In other cases, Excel 2007 has new and better features that replace old functionality using new nomenclature and renamed or repositioned commands. Also, Microsoft has removed a few Excel 2003 commands from Excel 2007. We've organized this appendix to reflect the Excel 2003 menu structure.
This appendix includes commands from all the menus but includes only the Standard and Formatting toolbars, which are usually displayed in Excel 2003. For information about the location of buttons on any of the 19 other toolbars, click the Help button, and type Excel 2003 commands in the Search box. Click the Reference topic where you can download a workbook containing lists of all the menu commands and toolbar buttons in Excel 2003 with their 2007 counterparts.
File Menu
| Menu | Excel 2003 Location | Excel 2007 Location |
|---|---|---|
| File | Menu | Microsoft Office Button |
| File | New | Microsoft Office Button, New |
| File | Open | Microsoft Office Button, Open |
| File | Close | Microsoft Office Button, Close |
| File | Save | Quick Access Toolbar, Save |
| File | Save | Microsoft Office Button, Save |
| File | Save As | Microsoft Office Button, Save As |
| File | Save As Web Page | Microsoft Office Button, Save As, Save As Type, Web Page |
| File | Save Workspace | View tab, Window group, Save Workspace command |
| File | File Search | Windows Start button, Search |
| File | Permission, Unrestricted Access | Review tab, Changes group, Protect Workbook command, clear the Structure and Windows check boxes under Protect Workbook For |
| File | Permission, Do Not Distribute | Removed |
| File | Permission, Restrict Permission As | Review tab, Changes group, Track Changes, Highlight Changes, then specify Who, When, and Where. |
| File | Check Out | Microsoft Office Button, Server, Check Out |
| File | Check In | Microsoft Office Button, Server, Check In |
| File | Version History | Microsoft Office Button, Server, View Version History |
| File | Web Page Preview | You must add a button to the Quick Access Toolbar for this command: Microsoft Office Button, Excel Options, Customize category, All Commands, Web Page Preview |
| File | Page Setup | Page Layout tab, Page Setup group, Page Setup Dialog Box Launcher |
| File | Print Area, Set Print Area | Page Layout tab, Page Setup group, Print Area command, Set Print Area command |
| File | Print Area, Clear Print Area | Page Layout tab, Page Setup group, Print Area command, Clear Print Area command |
| File | Print Preview | Microsoft Office Button, Print, Print Preview |
| File | | Microsoft Office Button, Print |
| File | | Microsoft Office Button, Print, Print Preview tab, Print command |
| File | Send To, Mail Recipient | You must add a button to the Quick Access Toolbar for this command: Microsoft Office Button, Excel Options, Customize category, All Commands, Mail Recipient |
| File | Send To, Original Sender | Removed |
| File | Send To, Mail Recipient (For Review) | You must add a button to the Quick Access Toolbar for this command: Microsoft Office Button, Excel Options, Customize category, All Commands, Send For Review |
| File | Send To, Mail Recipient (As Attachment) | Microsoft Office Button, Send, E-Mail |
| File | Send To, Routing Recipient | Removed |
| File | Send To, Exchange Folder | You must add a button to the Quick Access Toolbar for this command: Microsoft Office Button, Excel Options, Customize category, All Commands, Send To Exchange Folder |
| File | Send To, Online Meeting Participant | Removed |
| File | Send To, Recipient Using Internet Fax Service | Microsoft Office Button, Send, Internet Fax |
| File | Properties | Microsoft Office Button, Prepare, Properties |
| File | Most Recently Used Documents | Microsoft Office Button, Recent Documents |
| File | Exit | Microsoft Office Button, Exit Excel |
| File | Sign Out | Removed |
Open table as spreadsheet
Edit Menu
| Menu | Excel 2003 Location | Excel 2007 Location |
|---|---|---|
| Edit | Undo | Quick Access Toolbar, Undo |
| Edit | Redo | Quick Access Toolbar, Redo |
| Edit | Cut | Home tab, Clipboard group, Cut command |
| Edit | Copy | Home tab, Clipboard group, Copy command |
| Edit | Office Clipboard | Home tab, Clipboard group, Clipboard Dialog Box Launcher |
| Edit | Paste | Home tab, Clipboard group, Paste command |
| Edit | Paste Special | Home tab, Clipboard group, Paste command, Paste Special command |
| Edit | Paste As Hyperlink | Home tab, Clipboard group, Paste command, Paste As Hyperlink command |
| Edit | Fill, Down | Home tab, Editing group, Fill command, Down command |
| Edit | Fill, Right | Home tab, Editing group, Fill command, Right command |
| Edit | Fill, Up | Home tab, Editing group, Fill command, Up command |
| Edit | Fill, Left | Home tab, Editing group, Fill command, Left command |
| Edit | Fill, Across Worksheets | Home tab, Editing group, Fill command, Across Worksheets command |
| Edit | Fill, Series | Home tab, Editing group, Fill command, Series command |
| Edit | Fill, Justify | Home tab, Editing group, Fill command, Justify command |
| Edit | Clear, All | Home tab, Editing group, Clear command, Clear All command |
| Edit | Clear, Formats | Home tab, Editing group, Clear command, Clear Formats command |
| Edit | Clear, Contents | Home tab, Editing group, Clear command, Clear Contents command |
| Edit | Clear, Comments | Home tab, Editing group, Clear command, Clear Comments command |
| Edit | Delete | Home tab, Cells group, Delete command |
| Edit | Delete Sheet | Home tab, Cells group, Delete command, Delete Sheet command |
| Edit | Move Or Copy Sheet | Home tab, Cells group, Format command, Move Or Copy Sheet command |
| Edit | Find | Home tab, Editing group, Find & Select command, Find command |
| Edit | Replace | Home tab, Editing group, Find & Select command, Replace command |
| Edit | Go To | Home tab, Editing group, Find & Select command, Go To command |
| Edit | Links | You must add a button to the Quick Access Toolbar for this command: Microsoft Office Button, Excel Options, Customize, All Commands, Edit Links |
| Edit | Object | Select an object to see its associated drawing tools |
| Edit | Clear, Series | Removed |
View Menu
| Menu | Excel 2003 Location | Excel 2007 Location |
|---|---|---|
| View | Normal | View tab, Workbook Views group, Normal command |
| View | Page Break Preview | View tab, Workbook Views group, Page Break Preview command |
| View | Task Pane | In some groups, Dialog Box Launchers will display a task pane instead of a dialog box. For example, Home tab, Clipboard group, Clipboard Dialog Box Launcher. |
| View | Toolbars, Standard | There is only one toolbar now, but these commands are available on the Home tab and from the Microsoft Office Button. |
| View | Toolbars, Formatting | There is only one toolbar now, but these commands are available on the Home tab. |
| View | Toolbars, Borders | There is only one toolbar now, but these commands are available on the Home tab, Font group, Borders command. |
| View | Toolbars, Chart | There is only one toolbar now, but these commands are available on the Chart Tools tabs when you insert or select a chart. |
| View | Toolbars, Control Toolbox | There is only one toolbar now, but these commands are available on the Developer tab. To display the Developer tab, click the Microsoft Office Button, click Excel Options, select the Popular category, and then select the Show Developer Tab In The Ribbon check box. |
| View | Toolbars, Drawing | There is only one toolbar now, but these commands are available on the Drawing Tools tabs when you select or insert a shape. |
| View | Toolbars, External Data | There is only one toolbar now, but these commands are available on the Data tab. |
| View | Toolbars, Forms | There is only one toolbar now, but these commands are available on the Developer tab. To display the Developer tab, click the Microsoft Office Button, click Excel Options, select the Popular category, and then select the Show Developer Tab In The Ribbon check box. |
| View | Toolbars, Formula Auditing | There is only one toolbar now, but these commands are available on the Formulas tab, Formula Auditing group. |
| View | Toolbars, List | There is only one toolbar now, but the majority of these commands are available on the Table Tools tabs when you select a cell in an Excel table. |
| View | Toolbars, Picture | There is only one toolbar now, but these commands are available on the Picture Tools tabs when you insert or select a picture. |
| View | Toolbars, PivotTable | There is only one toolbar now, but these commands are available on the PivotTable Tools tabs when you insert or select a cell in a PivotTable. |
| View | Toolbars, Protection | There is only one toolbar now, but these commands are available on the Review tab, Changes group |
| View | Toolbars, Reviewing | There is only one toolbar now, but these commands are available on the Review tab. |
| View | Toolbars, Task Pane | In some groups, Dialog Box Launchers will display a task pane instead of a dialog box. For example, Home tab, Clipboard group, Dialog Box Launcher. |
| View | Toolbars, Text To Speech | Removed |
| View | Toolbars, Visual Basic | There is only one toolbar now, but these commands are available on the Developer tab. To display the Developer Tab, click the Microsoft Office Button, click Excel Options, select the Popular category, and then select the Show Developer Tab In The Ribbon check box. |
| View | Toolbars, Watch Window | There is only one toolbar now, but these commands are available on the Formulas tab, Formula Auditing group, Watch Window command. |
| View | Toolbars, Web | There is only one toolbar now, but these commands are available in the Excel Options dialog box. Click the Microsoft Office Button, click Excel Options, select the Customize category, and click All Commands in the Choose Commands From list. |
| View | Toolbars, WordArt | There is only one toolbar now, but these commands are available on the Drawing Tools tabs when you insert or select WordArt. |
| View | Toolbars, Customize | Click the Microsoft Office Button, click Excel Options, and select the Customize category. |
| View | Formula Bar | View tab, Show/Hide group, Formula Bar check box |
| View | Status Bar | The status bar is always visible by default. |
| View | Header And Footer | Insert tab, Text group, Header & Footer command |
| View | Comments | Review tab, Comments group, Show All Comments command |
| View | Custom Views | View tab, Workbook Views group, Custom Views command |
| View | Full Screen | View tab, Workbook Views group, Full Screen command |
| View | Zoom | View tab, Zoom group, Zoom command |
| View | Sized With Window | Removed |
| View | Chart Window | Removed |
Insert Menu
| Menu | Excel 2003 Location | Excel 2007 Location |
|---|---|---|
| Insert | Menu | Home tab, Cells group, Insert command |
| Insert | Rows | Home tab, Cells group, Insert command, Insert Sheet Rows command |
| Insert | Columns | Home tab, Cells group, Insert command, Insert Sheet Columns command |
| Insert | Worksheet | Home tab, Cells group, Insert command, Insert Sheet command |
| Insert | Chart | Insert tab, Charts group |
| Insert | Symbol | Insert tab, Text group, Symbol command |
| Insert | Page Break | Page Layout tab, Page Setup group, Breaks command, Insert Page Break command |
| Insert | Reset All Page Breaks | Page Layout tab, Page Setup group, Breaks command, Reset All Page Breaks command |
| Insert | Function | Formulas tab, Function Library group, Insert Function command |
| Insert | Function | Formulas tab, Function Library group, Date & Time command, Insert Function command |
| Insert | Function | Formulas tab, Function Library group, Math & Trig command, Insert Function command |
| Insert | Function | Formulas tab, Function Library group, Financial command, Insert Function command |
| Insert | Function | Formulas tab, Function Library group, Logical command, Insert Function command |
| Insert | Function | Formulas tab, Function Library group, Lookup & Reference command, Insert Function command |
| Insert | Function | Formulas tab, Function Library group, Recently Used command, Insert Function command |
| Insert | Function | Formulas tab, Function Library group, Text command, Insert Function command |
| Insert | Function | Formulas tab, Function Library group, More Functions command, Cube command, Insert Function command |
| Insert | Function | Formulas tab, Function Library group, More Functions command, Engineering command, Insert Function command |
| Insert | Function | Formulas tab, Function Library group, More Functions command, Information command, Insert Function command |
| Insert | Function | Formulas tab, Function Library group, More Functions command, Statistical command, Insert Function command |
| Insert | Name, Define | Formulas tab, Defined Names group, Name Manager |
| Insert | Name, Paste | Formulas tab, Defined Names group, Use In Formula command, Paste Names command |
| Insert | Name, Create | Formulas tab, Defined Names group, Create From Selection command |
| Insert | Name, Apply | Formulas tab, Defined Names group, Define Name command, Apply Names command |
| Insert | Name, Label | Formulas tab, Defined Names group, Define Name command |
| Insert | Comment | Review tab, Comments group, New Comment command |
| Insert | Ink Annotations | Review tab, Ink, Start Inking (Tablet PC only) |
| Insert | Picture, Clip Art | Insert tab, Illustrations group, Clip Art command |
| Insert | Picture, From File | Insert tab, Illustrations group, Picture command |
| Insert | Picture, From File | Layout tab under Chart Tools, Insert group, Picture command |
| Insert | Picture, From File | Layout tab under PivotChart Tools, Insert tab, Picture group |
| Insert | Picture, From Scanner Or Camera | Removed |
| Insert | Picture, Ink Drawing And Writing | Review tab, Ink, Start Inking (Tablet PC only) |
| Insert | Picture, AutoShapes | Insert tab, Illustrations group, Shapes command |
| Insert | Picture, WordArt | Insert tab, Illustrations group, WordArt command |
| Insert | Picture, Organization Chart | insert tab, Illustrations group, SmartArt command |
| Insert | Diagram | Insert tab, Illustrations group, SmartArt command |
| Insert | Object | Insert tab, Text group, Object command |
| Insert | Hyperlink | Insert tab, Links group, Hyperlink command |
Format Menu
| Menu | Excel 2003 Location | Excel 2007 Location |
|---|---|---|
| Format | Cells | Home tab, Cells group, Format command, Format Cells command |
| Format | Row, Height | Home tab, Cells group, Format command, Row Height command |
| Format | Row, AutoFit | Home tab, Cells group, Format command, AutoFit Row Height command |
| Format | Row, Hide | Home tab, Cells group, Format command, Hide & Unhide command, Hide Rows command |
| Format | Row, Unhide | Home tab, Cells group, Format command, Hide & Unhide command, Unhide Rows command |
| Format | Column, Width | Home tab, Cells group, Format command, Column Width command |
| Format | Column, AutoFit Selection | Home tab, Cells group, Format command, AutoFit Column Width command |
| Format | Column, Hide | Home tab, Cells group, Format command, Hide & Unhide command, Hide Columns command |
| Format | Column, Unhide | Home tab, Cells group, Format command, Hide & Unhide, Unhide Columns command |
| Format | Column, Standard Width | Home tab, Cells group, Format command, Default Width command |
| Format | Sheet, Rename | Home tab, Cells group, Format command, Rename Sheet command |
| Format | Sheet, Hide | Home tab, Cells group, Format command, Hide & Unhide command, Hide Sheet command |
| Format | Sheet, Unhide | Home tab, Cells group, Format command, Hide & Unhide, Unhide Sheet command |
| Format | Sheet, Background | Page Layout tab, Page Setup group, Background command |
| Format | Sheet, Tab Color | Home tab, Cells group, Format command, Tab Color command |
| Format | AutoFormat | Home tab, Styles group, Format As Table command |
| Format | Conditional Formatting | Home tab, Styles group, Conditional Formatting command |
| Format | Style | Home tab, Styles group, Cell Styles command |
Tools Menu
| Menu | Excel 2003 Location | Excel 2007 Location |
|---|---|---|
| Tools | Spelling | Review tab, Proofing group, Spelling command |
| Tools | Research | Review tab, Proofing group, Research command |
| Tools | Error Checking | Formulas tab, Formula Auditing group, Error Checking command |
| Tools | Speech, Show Text To Speech Toolbar | Removed |
| Tools | Speech | Removed |
| Tools | Shared Workspace | Microsoft Office Button, Publish, Create Document Workspace |
| Tools | Share Workbook | Review tab, Changes group, Share Workbook command |
| Tools | Track Changes, Highlight Changes | Review tab, Changes group, Track Changes command, Highlight Changes command |
| Tools | Track Changes, Accept Or Reject Changes | Review tab, Changes group, Track Changes command, Accept/Reject Changes command |
| Tools | Compare And Merge Workbooks | You must add a button to the Quick Access Toolbar for this command: Microsoft Office Button, Excel Options, Customize, All Commands, Compare And Merge Workbooks |
| Tools | Protection, Protect Sheet | Review tab, Changes group, Protect Sheet command |
| Tools | Protection, Protect Sheet | Home tab, Cells group, Format command, Protect Sheet command |
| Tools | Protection, Allow Users To Edit Ranges | Review tab, Changes group, Allow Users To Edit Ranges command |
| Tools | Protection, Protect Workbook | Review tab, Changes group, Protect Workbook command |
| Tools | Protection, Protect And Share Workbook | Review tab, Changes group, Protect And Share Workbook command |
| Tools | Online Collaboration, Meet Now | Removed |
| Tools | Online Collaboration, Schedule Meeting | Removed |
| Tools | Online Collaboration, Web Discussions | Removed |
| Tools | Online Collaboration, End Review | Removed |
| Tools | Goal Seek | Data tab, Data Tools group, What-lf Analysis command, Goal Seek command |
| Tools | Scenarios | Data tab, Data Tools group, What-lf Analysis command, Scenario Manager command |
| Tools | Formula Auditing, Trace Precedents | Formulas tab, Formula Auditing group, Trace Precedents command |
| Tools | Formula Auditing, Trace Dependents | Formulas tab, Formula Auditing group, Trace Dependents command |
| Tools | Formula Auditing, Trace Error | Formulas tab, Formula Auditing group, Error Checking command, Trace Error command |
| Tools | Formula Auditing, Remove All Arrows | Formulas tab, Formula Auditing group, Remove Arrows command |
| Tools | Formula Auditing, Evaluate Formula | Formulas tab, Formula Auditing group, Evaluate Formula command |
| Tools | Formula Auditing, Hide Watch Window | Formulas tab, Formula Auditing group, Watch Window command |
| Tools | Formula Auditing, Formula Auditing Mode | Formulas tab, Formula Auditing group, Show Formulas command |
| Tools | Formula Auditing, Show Formula Auditing Toolbar | Formulas tab, Formula Auditing group |
| Tools | Macro, Macros | Developer tab, Code group, Macros command |
| Tools | Macro, Macros | View tab, Macros group, Macros command |
| Tools | Macro, Record New Macro | Developer tab, Code group, Record Macro command |
| Tools | Macro, Record New Macro | View tab, Macros group, Macros command, Record Macro command |
| Tools | Macro, Security | Developer tab, Code group, Macro Security command |
| Tools | Macro, Visual Basic Editor | Developer tab, Code group, Visual Basic command |
| Tools | Macro, Microsoft Script Editor | Removed |
| Tools | Add-lns | Microsoft Office Button, Excel Options, Add-lns category |
| Tools | AutoCorrect Options | Microsoft Office Button, Excel Options, Proofing category, AutoCorrect Options |
| Tools | Customize | Microsoft Office Button, Excel Options, Customize category |
| Tools | Show Signatures | Microsoft Office Button, Prepare, Add a Digital Signature |
| Tools | Options | Microsoft Office Button, Excel Options |
Data Menu
| Menu | Excel 2003 Location | Excel 2007 Location |
|---|---|---|
| Data | Sort | Data tab, Sort & Filter group, Sort command |
| Data | Filter | Data tab, Sort & Filter group, Filter command |
| Data | Filter, AutoFilter | Home tab, Editing group, Sort & Filter, Filter command |
| Data | Filter, Show All | Data tab, Sort & Filter group, Clear command |
| Data | Filter, Show All | Home tab, Editing group, Sort & Filter, Clear command |
| Data | Filter, Advanced Filter | Data tab, Sort & Filter group, Advanced command |
| Data | Form | You must add a button to the Quick Access Toolbar for this command: Microsoft Office Button, Excel Options, Customize category, All Commands, Form |
| Data | Subtotals | Data tab, Outline group, Subtotal command |
| Data | Validation | Data tab, Data Tools group, Data Validation command |
| Data | Table | Data tab, Data Tools group, What-lf Analysis command, Data Table command |
| Data | Text To Columns | Data tab, Data Tools group, Convert Text To Table command |
| Data | Consolidate | Data tab, Data Tools group, Consolidate command |
| Data | Group And Outline, Hide Detail | Data tab, Outline group, Hide Detail command |
| Data | Group And Outline, Show Detail | Data tab, Outline group, Show Detail command |
| Data | Group And Outline, Group | Data tab, Outline group, Group command |
| Data | Group And Outline, Group | Options tab under PivotTable Tools, Group group |
| Data | Group And Outline, Ungroup | Data tab, Outline group, Ungroup command |
| Data | Group And Outline, Ungroup | Options tab under PivotTable Tools, Ungroup command |
| Data | Group And Outline, Auto Outline | Data tab, Outline group, Group command, Auto Outline command |
| Data | Group And Outline, Clear Outline | Data tab, Outline group, Ungroup command, Clear Outline command |
| Data | Group And Outline, Settings | Data tab, Outline group, Dialog Box Launcher button |
| Data | PivotTable And PivotChart Report | Insert tab, Tables group, PivotTable command, PivotTable/PivotChart command |
| Data | Import External Data, Import Data | Data tab, Get External Data group |
| Data | Import External Data, New Web Query | Data tab, Get External Data group, From Web command |
| Data | Import External Data, New Database Query | Data tab, Get External Data group, From Other Sources command, From Microsoft Query command |
| Data | Import External Data, Edit Query | You must add a button to the Quick Access Toolbar for this command: Microsoft Office Button, Excel Options, Customize category, All Commands, Edit Query |
| Data | Import External Data, Data Range Properties | Data tab, Connections group, Properties command |
| Data | Import External Data, Data Range Properties | Design tab under Table Tools, External Table Data command, Properties command |
| Data | Import External Data, Parameters | You must add a button to the Quick Access Toolbar for this command: Microsoft Office Button, Excel Options, Customize category, All Commands, Parameters |
| Data | List, Create List | Insert tab, Tables group, Table command |
| Data | List, Resize List | Design tab under Table Tools, Properties command, Resize Table command |
| Data | List, Total Row | Design tab under Table Tools, Table Style Options group, Total Row check box |
| Data | List, Convert To Range | Design tab under Table Tools, Tools group, Convert To Range command |
| Data | List, Publish List | Design tab under Table Tools, External Table Data group, Export command, Export Table To SharePoint List command |
| Data | List, View List On Server | Design tab under Table Tools, External Table Data group, Open In Browser command |
| Data | List, Unlink List | Design tab under Table Tools, External Table Data group, Unlink command |
| Data | List, Synchronize List | You must add a button to the Quick Access Toolbar for this command: Microsoft Office Button, Excel Options, Customize category, All Commands, Synchronize List |
| Data | List, Discard Changes And Refresh | You must add a button to the Quick Access Toolbar for this command: Microsoft Office Button, Excel Options, Customize category, All Commands, Discard Changes And Refresh |
| Data | List, Hide Border Of Inactive Lists | Removed |
| Data | XML, Import | Developer tab, XML group, Import command |
| Data | XML, Export | Developer tab, XML group, Export command |
| Data | XML, Refresh XML Data | Developer tab, XML group, Refresh Data command |
| Data | XML, XML Source | Developer tab, XML group, Source command |
| Data | XML, XML Map Properties | Developer tab, XML group, Map Properties command |
| Data | XML, Edit Query | Removed |
| Data | XML, XML Expansion Packs | Developer tab, XML group, Expansion Packs command |
| Data | Refresh Data | Analyze tab under PivotChart Tools, Data group, Refresh command |
| Data | Refresh Data | Options tab under PivotTable Tools, Data group, Refresh command |
| Data | Refresh Data | Design tab under Table Tools, External Table Data group, Refresh command |
| Data | Refresh Data | Data tab, Connections group, Refresh All command, Refresh command |
| Data | Refresh Data | Analyze tab under PivotChart Tools, Data group, Refresh command, Refresh command |
| Data | Refresh Data | Options tab under PivotTable Tools, Data group, Refresh command, Refresh command |
| Data | Refresh Data | Design tab under Table Tools, External Table Data group, Refresh command, Refresh command |
Chart Menu
| Menu | Excel 2003 Location | Excel 2007 Location |
|---|---|---|
| Chart | Chart Type | Design tab under Chart Tools, Type group, Change Chart Type command |
| Chart | Select Data | Design tab under Chart Tools, Data group, Select Data command |
| Chart | Source Data | Design tab under PivotChart Tools, Data group, Select Data command |
| Chart | Chart Options | Layout tab under Chart Tools |
| Chart | Location | Design tab under Chart Tools, Location group, Move Chart command |
| Chart | Location | Design tab under PivotChart Tools, Location group, Move Chart command |
| Chart | Add Data | Design tab under Chart Tools, Data group, Select Data command |
| Chart | Add Trendline | Layout under Chart Tools, Analysis group, Trendline command |
| Chart | 3-D View | Layout under Chart Tools, Background group, 3-D View command |
Window Menu
| Menu | Excel 2003 Location | Excel 2007 Location |
|---|---|---|
| Window | New Window | View tab, Window group, New Window command |
| Window | Arrange All | View tab, Window group, Arrange All command |
| Window | Compare Side By Side With | View tab, Window group, View Side By Side command |
| Window | Hide | View tab, Window group, Hide command |
| Window | Unhide | View tab, Window group, Unhide command |
| Window | Split | View tab, Window group, Split command |
| Window | Freeze Panes | View tab, Window group, Freeze Panes command |
| Window | Currently Open Workbooks | View tab, Window group, Switch Windows command |
Help Menu
| Menu | Excel 2003 Location | Excel 2007 Location |
|---|---|---|
| Help | Menu | Upper Ribbon, Help (the "question mark" button) |
| Help | Microsoft Office Online | Microsoft Office Button, Excel Options, Resources category, Microsoft Office Online |
| Help | Contact Us | Microsoft Office Button, Excel Options, Resources category, Contact Us |
| Help | Check For Updates | Microsoft Office Button, Excel Options, Resources category, Check For Updates |
| Help | Detect And Repair | Microsoft Office Button, Excel Options, Resources category, Diagnose |
| Help | Activate Product | Microsoft Office Button, Excel Options, Resources category, Activate |
| Help | About Microsoft Office Excel | Microsoft Office Button, Excel Options, Resources category, About |
| Help | Show The Office Assistant | Removed |
Standard Toolbar
| Menu | Excel 2003 Location | Excel 2007 Location |
|---|---|---|
| Standard toolbar | New | Microsoft Office Button, New, Blank Worksheet |
| Standard toolbar | Open | Microsoft Office Button, Open |
| Standard toolbar | Save | Quick Access Toolbar, Save |
| Standard toolbar | Save | Microsoft Office Button, Save |
| Standard toolbar | Permission | Review tab, Changes group, Track Changes, Highlight Changes, then specify Who, When, and Where |
| Standard toolbar | | Microsoft Office Button, Send, E-Mail |
| Standard toolbar | | Microsoft Office Button, Print, Quick Print |
| Standard toolbar | Print Preview | Microsoft Office Button, Print, Print Preview |
| Standard toolbar | Spelling | Review tab, Proofing group, Spelling command |
| Standard toolbar | Research | Review tab, Proofing group, Research command |
| Standard toolbar | Cut | Home tab, Clipboard group, Cut command |
| Standard toolbar | Copy | Home tab, Clipboard group, Copy command |
| Standard toolbar | Paste | Home tab, Clipboard group, Paste command |
| Standard toolbar | Format Painter | Home tab, Clipboard group, Format Painter command |
| Standard toolbar | Undo | Quick Access Toolbar, Undo |
| Standard toolbar | Redo | Quick Access Toolbar, Redo |
| Standard toolbar | Ink Annotations | Review tab, Ink, Start Inking (Tablet PC only) |
| Standard toolbar | Hyperlink | Insert tab, Links group, Hyperlink command |
| Standard toolbar | AutoSum | Home tab, Editing group, AutoSum command |
| Standard toolbar | AutoSum | Formulas tab, Function Library group, AutoSum command |
| Standard toolbar | Sort Ascending | Data tab, Sort & Filter group, Sort A To Z command |
| Standard toolbar | Sort Descending | Data tab, Sort & Filter group, Sort Z To A command |
| Standard toolbar | Chart Wizard | Insert tab, Charts group |
| Standard toolbar | Drawing | These commands are available in the Drawing Tools tabs when you insert or select a shape. |
| Standard toolbar | Zoom | View tab, Zoom group, Zoom command |
| Standard toolbar | Microsoft Excel Help | Upper Ribbon, Help |
| Standard toolbar | PivotTable And PivotChart Report | Insert tab, Tables group, PivotTable command, PivotTable or PivotChart command |
| Standard toolbar | Comment | Review tab, Comments group, New Comment command |
| Standard toolbar | AutoFilter | This functionality is now added when you create a table. Otherwise, you must add a button to the Quick Access Toolbar for this command: Microsoft Office Button, Excel Options, Customize category, All Commands, AutoFilter |
Formatting Toolbar
| Menu | Excel 2003 Location | Excel 2007 Location |
|---|---|---|
| Formatting toolbar | Font | Home tab, Font group, Font command |
| Formatting toolbar | Font Size | Home tab, Font group, Font Size command |
| Formatting toolbar | Bold | Home tab, Font group, Bold command |
| Formatting toolbar | Italic | Home tab, Font group, Italic command |
| Formatting toolbar | Underline | Home tab, Font group, Underline command, Underline command |
| Formatting toolbar | Align Left | Home tab, Alignment group, Align Left command |
| Formatting toolbar | Center | Home tab, Alignment group, Center command |
| Formatting toolbar | Align Right | Home tab, Alignment group, Align Right command |
| Formatting toolbar | Merge And Center | Home tab, Alignment group, Merge & Center command |
| Formatting toolbar | Currency Style | Home tab, Number group, Accounting Number Format command |
| Formatting toolbar | Percent Style | Home tab, Number group, Percent Style command |
| Formatting toolbar | Comma Style | Home tab, Number group, Comma Style command |
| Formatting toolbar | Increase Decimal | Home tab, Number group, Increase Decimal command |
| Formatting toolbar | Decrease Decimal | Home tab, Number group, Decrease Decimal command |
| Formatting toolbar | Decrease Indent | Home tab, Alignment group, Decrease Indent command |
| Formatting toolbar | Increase Indent | Home tab, Alignment group, Increase Indent command |
| Formatting toolbar | Borders | Home tab, Font group, Borders command |
| Formatting toolbar | Fill Color | Home tab, Font group, Fill Color command |
| Formatting toolbar | Font Color | Home tab, Font group, Font Color command |
| Formatting toolbar | Chart, Chart Type | Design tab under Chart Tools, Type group, Change Chart Type command |
| Formatting toolbar | Chart, Source Data | Design tab under Chart Tools, Data group, Select Data command |
| Formatting toolbar | Chart, Source Data | Design tab under PivotChart Tools, Data group, Select Data command |
| Formatting toolbar | Chart, Chart Options | Layout tab under Chart Tools |
| Formatting toolbar | Chart, Location | Design tab under Chart Tools, Location group, Move Chart command |
| Formatting toolbar | Chart, Location | Design tab under PivotChart Tools, Location group, Move Chart command |
| Formatting toolbar | Chart, Add Data | Design tab under Chart Tools, Data group, Select Data command |
| Formatting toolbar | Chart, Add Trendline | Layout tab under Chart Tools, Analysis group, Trendline command |
| Formatting toolbar | Chart, 3-D View | Layout tab under Chart Tools, Background group, 3-D View command |
| Formatting toolbar | AutoFormat | Home tab, Styles group, Format As Table command |
| Formatting toolbar | Cells | Home tab, Cells group, Format command |
| Formatting toolbar | Increase Font Size | Home tab, Font group, Increase Font Size command |
| Formatting toolbar | Decrease Font Size | Home tab, Font group, Decrease Font Size command |
| Formatting toolbar | Text Direction | Home tab, Alignment group, Orientation command |
EAN: 2147483647
Pages: 260