Pin Me

Printable Quick Guide: Compare Excel 2003 to Excel 2007

written by: •edited by: Michele McDonough•updated: 12/7/2009

You have used Excel 2003 and earlier, comparable versions for years. You know your way around all the toolbars, or at least have an idea about where to look. The Excel 2007 ribbon is unfamiliar and a bit daunting. Refer to this quick guide to learn where to find almost anything in Excel 2007.

  • slide 1 of 12

    Overview

    Each section in this quick guide refers to a toolbar menu in Excel 2003. You can peruse each toolbar menu to learn where the items are in Excel 2007, print this quick guide to keep on hand as a reference, or if you need to know where to find a specific command quickly, use the keyboard shortcut Ctrl+F. This will open your browser's Find window. Type in the command or the toolbar menu name into the Find box and press Enter. This will take you directly through the guide to the Excel tool or function you seek.

    The first page of this article lists the commands in the File, Edit, View and Insert menus. Go to page 2 of this article for the remaining menu lists.

    Also, if you are a fan of keyboard shortcuts, most of your old faithful Excel shortcuts will work just as nicely in Excel 2007.

  • slide 2 of 12

    File Menu

    These are the commands listed in the File menu in Excel 2003. Follow this quick guide to learn where you can find them in Excel 2007.

    New: click the Office Button and then click New

    Open: click the Office Button and then click Open

    Close: click the Office Button and then click Close

    Save: click Save on the Quick Access Toolbar

    Save As: click the Office Button and then click Save As

    Save As Webpage: click the Office Button and then click Save As. Select Save As Webpage in the Save As Filetype box on the Save As dialog.

    Save As Workspace: go to the View tab and click Save As Workspace in the Window group.

    File Search: this command is not available in Excel 2007. Use the Search feature in the Windows Start Menu instead.

    Permissions: click the Office Button, click Prepare, click Restrict Permission and then select the type of permission you wish to apply.

    Web Page Preview: you will need to add this command to the Quick Access Toolbar. You can find instructions on customizing the QAT in this Bright Hub article.

    Page Setup: go to the Page Setup tab and click the arrow at the bottom right of the Page Setup section.

    Print Area: go to the Page Setup tab and click Print Area

    Print Preview: click the Office Button, click Print and click Print Preview

    Print: click the Office Button and click Print

    Send To: you will need to add this command to the Quick Access Toolbar. You can find instructions on customizing the QAT in this Bright Hub article.

    Properties: click the Office Button, click Prepare and click Properties

    Exit: click the Office Button and click Exit

  • slide 3 of 12

    Edit Menu

    These are the commands listed in the Edit menu in Excel 2003. Follow this quick guide to learn where you can find them in Excel 2007.

    Undo: click Undo on the Quick Access Toolbar

    Redo: click Redo on the Quick Access Toolbar

    Cut: go to the Home tab and click Cut in the Clipboard group

    Copy: go to the Home tab and click Copy in the Clipboard group

    Office Clipboard: go to the Home tab and click the arrow in the bottom right of the Clipboard group

    Paste: go to the Home tab and click Paste in the Clipboard group

    Paste Special: go to the Home tab and click the arrow under Paste in the Clipboard group; select Paste Special

    Paste As Hyperlink: go to the Home tab and click the arrow under Paste in the Clipboard group; select Paste as Hyperlink

    Fill: go to the Home tab and click Fill in the Editing group

    Clear: go to the Home tab and click Clear in the Editing group

    Delete: go to the Home tab and click Delete in the Cells group

    Delete Sheet: go to the Home tab and click the arrow next to Delete in the Cells group; select Delete Sheet

    Move or Copy Sheet: go to the Home tab and click Format in the Cells group; select Move or Copy Sheet

    Find: go to the Home tab and click Find & Select in the Editing group

    Replace: go to the Home tab and click Find & Select in the Editing group

    Go To: go to the Home tab and click Find & Select in the Editing group

    Links: click the Office Button, click Prepare and click Edit Links to Files

  • slide 4 of 12

    View Menu

    These are the commands listed in the View menu in Excel 2003. Follow this quick guide to learn where you can find them in Excel 2007.

    Normal: go to the View tab and click Normal in the Workbook Views group

    Page Break Preview: go to the View tab and click Page Break Preview in the Workbook Views group

    Toolbars: because Excel 2007 uses the "Ribbon" rather than toolbars, this menu item is not applicable

    Formula Bar: go to the View tab and click Formula Bar in the Show/Hide group

    Status Bar: the Status Bar is displayed by default in Excel 2007

    Header and Footer: go to the Insert tab and click Header&Footer in the Text group

    Comments: go to the Review tab and click Show All Comments in the Comments group

    Custom Views: go to the View tab and click Custom Views in the Workbook Views group

    Full Screen: go to the View tab and click Full Screen in the Workbook Views group

    Zoom: go to the View tab and click Zoom in the Zoom group

  • slide 5 of 12

    Insert Menu

    These are the commands listed in the Insert menu in Excel 2003. Follow this quick guide to learn where you can find them in Excel 2007.

    Cells: go to the Home tab and click Insert Cells in the Cells group

    Rows: go to the Home tab and click Insert Rows in the Cells group

    Columns: go to the Home tab and click Insert Columns in the Cells group

    Worksheet: go to the Home tab and click Insert Worksheet in the Cells group

    Chart: go to the Insert tab and select an option in the Charts group

    Symbol: go to the Insert tab and click Symbol in the Text group

    Page Break: go to the Page Layout tab and click Breaks in the Page Setup group

    Function: go to the Formulas tab and click Insert Function in the Function Library group

    Name: go to the Formulas tab and select an option in the Defined Names group

    Ink Annotations: go to the Review tab and click Start Inking in the Ink group

    Comment: go to the Review tab and click New Comments in the Comments group

    Picture: go to the Insert tab and make a selection from the Illustrations group

    Diagram: go to the Insert tab and click Smart Art in the Illustrations group

    Object: go to the Insert tab and click Object in the Text group

    Hyperlink: go to the Insert tab and click Hyperlink in the Links group

  • slide 6 of 12
    Continuation of a printable guide to help you quickly find commands in Excel 2007. If you know where to find commands in Excel 2003, check out this list and it will direct you to them in Excel 2007 as well. This section of the printable Excel 2003 to Excel 2007 guide lists details for the Format, Tools, Data, Window and Help menus.
  • slide 7 of 12

    Format Menu

    These are the commands listed in the Format menu in Excel 2003. Follow this quick guide to learn where you can find them in Excel 2007.

    Cells: go to the Home tab and click Format in the Cells group; select Format Cells

    Rows: go to the Home tab and click Format in the Cells group; make a selection such as Row Height

    Columns: go to the Home tab and click Format in the Cells group; make a selection such as Column Width

    Sheets: go to the Home tab and click Format in the Cells group; make a selection such as Rename Sheet

    AutoFormat: go to the Home tab and click Format as Table in the Styles group

    Conditional Formatting: go to the Home tab and click Conditional Formatting in the Styles group

    Style: go to the Home tab and click Cell Styles in the Styles group

  • slide 8 of 12

    Tools Menu

    These are the commands listed in the Tools menu in Excel 2003. Follow this quick guide to learn where you can find them in Excel 2007.

    Spelling: go to the Review tab and click Spelling in the Proofing group

    Research: go to the Review tab and click Research in the Proofing group

    Error Checking: go to the Formulas tab and click Error Checking in the Formula Auditing group

    Speech: this command is not available in Excel 2007, although there are some third-party add-ins that might replicate this command

    Shared Workspace: click the Office Button, click Publish and then click Create Document Workspace

    Share Workbook: go to the Review tab and click Share Workbook in the Changes group

    Track Changes: go to the Review tab and click Track Changes in the Changes group

    Protection: go to the Review tab and click Protect Workbook in the Changes group

    Goal Seek: go to the Data tab and click What If Analysis in the Data Tools group; select Goal Seek

    Scenarios: go to the Data tab and click What If Analysis in the Data Tools group; select Scenario Manager

    Formula Auditing: go to the Formulas tab and make a selection from the Formula Auditing group

    Macro: in order to create macros in Excel 2007, you must turn on the Developer tab. Find instructions in this Bright Hub article.

    Add-Ins: click the Office Button, click Excel Options and then click Add-Ins

    AutoCorrect Options: click the Office Button, click Excel Options and then click AutoCorrect Options

    Customize: you cannot customize the Excel 2007 ribbon. However, you can add items to the Quick Access Toolbar. You can find instructions on customizing the QAT in this Bright Hub article.

    Options: click the Office Button and then click Excel Options

  • slide 9 of 12

    Data Menu

    These are the commands listed in the Data menu in Excel 2003. Follow this quick guide to learn where you can find them in Excel 2007.

    Sort: go to the Data tab and click Sort in the Sort & Filter group

    Filter: go to the Data tab and select an option in the Sort & Filter group

    Form: you will need to add this command to the Quick Access Toolbar. You can find instructions on customizing the QAT in this Bright Hub article.

    Subtotals: go to the Data tab and click Subtotal in the Outline group

    Validation: go to the Data tab and click Data Validation in the Data Tools group

    Table: go to the Data tab and click What If Analysis in the Data Tools group; select Data Table

    Text to Columns: go to the Data tab and click Text to Columns in the Data Tools group

    Consolidate: go to the Data tab and click Consolidate in the Data Tools group

    Group and Outline: go to the Data tab and make a selection in the Outline group

    PivotTables: go to the Insert menu and select Pivot Table in the Tables group

    Import External Data: you will need to add this command to the Quick Access Toolbar. You can find instructions on customizing the QAT in this Bright Hub article.

    List: go to the Insert tab and select Table in the Tables group

    XML: in order to use XML commands, you must turn on the Developer tab. Find instructions in this Bright Hub article.

    Refresh Data: go to the Data tab and select Refresh All in the Connections group

  • slide 10 of 12

    Chart Menu

    These are the commands listed in the Chart menu in Excel 2003. Follow this quick guide to learn where you can find them in Excel 2007.

    Chart Type: select the chart, go to the Design tab and click Change Chart Type in the Type group

    Source Data: select the chart, go to the Design tab and click Select Data in the Data group

    Chart Options: select the chart and go to the Layout tab

    Locations: select the chart, go to the Design tab and click Move Chart in the Location group

    Add Data: select the chart, go to the Design tab and click Select Data in the Data group

    Add Trendline: select the chart, go to the Layout tab and click Trendline in the Analysis group

    3D Views: select the chart, go to the Layout tab and click 3-D Rotation in the Background group

  • slide 11 of 12

    Window Menu

    These are the commands listed in the Window menu in Excel 2003. Follow this quick guide to learn where you can find them in Excel 2007.

    New Window: go to the View tab and select New Window in the Window group

    Arrange: go to the View tab and select Arrange All in the Window group

    Compare Side by Side: go to the View tab and select View Side-by-Side in the Window group

    Hide: go to the View tab and select Hide in the Window group

    Unhide: go to the View tab and select Unhide in the Window group

    Split: go to the View tab and select Split in the Window group

    Freeze Panes: go to the View tab and select Freeze Panes in the Window group

    List of Windows: go to the View tab and select Switch Windows in the Window group; select List of Open Documents

  • slide 12 of 12

    Help Menu

    These are the commands listed in the Help menu in Excel 2003. Follow this quick guide to learn where you can find them in Excel 2007.

    Microsoft Office Help: Click the Question Mark at the right end of the ribbon

    Show the Office Assistant: This feature is not available in Excel 2007

    Microsoft Office Online: click the Office Button, click Excel Options and then click Register in the Resources group

    Contact Us: click the Office Button, click Excel Options and then click Contact Us in the Resources group

    Check for Updates: click the Office Button, click Excel Options and then click Check for Updates in the Resources group

    Detect and Repair: click the Office Button, click Excel Options and then click Diagnose in the Resources group

    Activate Product: click the Office Button, click Excel Options and then click Activate in the Resources group

    Customer Feedback Options: click the Office Button, click Excel Options and then go to the Trust Center group

    About Microsoft Excel: click the Office Button, click Excel Options and then click About in the Resources group