MS Excel 2003 -> 2007 Tools

Posted on by Jeff Feiertag
Excel 2003 Location  Excel 2007 Location
Spelling>Review | Proofing | Spelling
Research>Review | Proofing | Research
Error Checking>Formulas | Formula Auditing | Error Checking
Track Changes | Highlight Changes>Review | Changes | Track Changes | Highlight Changes
Track Changes | Accept or Reject Changes>Review | Changes | Track Changes | Accept/Reject Changes
Compare and Merge Workbooks>Office Button | Excel Options | Customize | All Commands | Compare and Merge Workbooks
Goal Seek>Data | Data Tools | What-If Analysis | Goal Seek
Scenarios>Data | Data Tools | What-If Analysis | Scenario Manager
Formula Auditing | Trace Precedents>Formulas | Formula Auditing | Trace Precedents
Formula Auditing | Trace Dependents>Formulas | Formula Auditing | Trace Dependents
Formula Auditing | Trace Error>Formulas | Formula Auditing | Error Checking | Trace Error
Formula Auditing | Remove All Arrows>Formulas | Formula Auditing | Remove Arrows
Formula Auditing | Remove All Arrows>Formulas | Formula Auditing | Remove Arrows | Remove Arrows
Formula Auditing | Evaluate Formula>Formulas | Formula Auditing | Evaluate Formula
Formula Auditing | Hide Watch Window>Formulas | Formula Auditing | Watch Window
Formula Auditing | Formula Auditing Mode►Formulas | Formula Auditing | Show Formulas
Formula Auditing | Show Formula Auditing Toolbar►Formulas | Formula Auditing
Macro | Macros►Developer | Code | Macros
Macro | Macros►View | Macros | Macros
Macro | Record New Macro►Developer | Code | Record Macro
Macro | Record New Macro►View | Macros | Macros | Record Macro
Macro | Security►Developer | Code | Macro Security
Macro | Visual Basic Editor►Developer | Code | Visual Basic
AutoCorrect Options►Office Button | Excel Options | Proofing | AutoCorrect Options
Options►Office Button | Excel Options

MS Excel 2003 -> 2007 Data

Posted on by Jeff Feiertag
Excel 2003 Location  Excel 2007 Location
Sort>Office Button | Excel Options | Customize | All Commands | Sort
Filter | AutoFilter>Data | Sort & Filter | Filter
Filter | AutoFilter>Home | Editing | Sort & Filter | Filter
Filter | Show All>Data | Sort & Filter | Clear
Filter | Show All>Home | Editing | Sort & Filter | Clear
Filter | Advanced Filter>Data | Sort & Filter | Advanced
Form>Office Button | Excel Options | Customize | All Commands | Form
Subtotals>Data | Outline | Subtotal
Validation>Data | Data Tools | Data Validation
Table>Data | Data Tools | What-If Analysis | Data Table
Text to Columns>Data | Data Tools | Convert Text to Table
Consolidate>Data | Data Tools | Consolidate
Group and Outline | Hide Detail>Data | Outline | Hide Detail
Group and Outline | Show Detail>Data | Outline | Show Detail
Group and Outline | Group>Data | Outline | Group
Group and Outline | Group>PivotTable Tools | Options | Group
Group and Outline | Ungroup>Data | Outline | Ungroup
Group and Outline | Ungroup>PivotTable Tools | Options | Ungroup
Group and Outline | Auto Outline>Data | Outline | Group | Auto Outline
Group and Outline | Clear Outline>Data | Outline | Ungroup | Clear Outline
Group and Outline | Settings>Data | Outline | Group and Outline Settings
PivotTable and PivotChart Report>Insert | Tables | PivotTable | PivotTable/PivotChart
Import External Data | Import Data>Data | Get External Data
Import External Data | New Web Query>Data | Get External Data | From Web
Import External Data | New Database Query>Data | Get External Data | From Other Sources | From Microsoft Query
Import External Data | Edit Query>Office Button | Excel Options | Customize | All Commands | Edit Query
Import External Data | Data Range Properties>Data | Connections | Properties
Import External Data | Data Range Properties>Table Tools | Design | External Table Data | Properties
Import External Data | Parameters>Office Button | Excel Options | Customize | All Commands | Parameters
List | Create List>Insert | Tables | Table
List | Resize List>Table Tools | Design | Properties | Resize Table
List | Total Row>Table Tools | Design | Table Style Options | Total Row
List | Convert to Range>Table Tools | Design | Tools | Convert to Range
List | Publish List>Table Tools | Design | External Table Data | Export | Export Table to SharePoint List
List | View List on Server>Table Tools | Design | External Table Data | Open in Browser
List | Unlink List>Table Tools | Design | External Table Data | Unlink
List | Synchronize List►Office Button | Excel Options | Customize | All Commands | Synchronize List
List | Discard Changes and Refresh►Office Button | Excel Options | Customize | All Commands | Discard Changes and Refresh
List | Hide Border of Inactive Lists►Removed from product
XML | Import►Developer | XML | Import
XML | Export►Developer | XML | Export
XML | Refresh XML Data►Developer | XML | Refresh Data
XML | XML Source►Developer | XML | Source
XML | XML Map Properties►Developer | XML | Map Properties
XML | Edit Query►Removed from product
XML | XML Expansion Packs►Developer | XML | Expansion Packs
Refresh Data►PivotChart Tools | Analyze | Data | Refresh
Refresh Data►PivotTable Tools | Options | Data | Refresh
Refresh Data►Table Tools | Design | External Table Data | Refresh
Refresh Data►Data | Connections | Refresh | Refresh
Refresh Data►PivotChart Tools | Analyze | Data | Refresh | Refresh
Refresh Data►PivotTable Tools | Options | Data | Refresh | Refresh
Refresh Data►Table Tools | Design | External Table Data | Refresh | Refresh

MS Excel 2003 -> 2007 Window

Posted on by Jeff Feiertag
Excel 2003 Location  Excel 2007 Location
New Window►View | Window | New Window
Arrange►View | Window | Arrange All
Compare Side by Side with►View | Window | View Side by Side
Hide►View | Window | Hide
Unhide►View | Window | Unhide
Split►View | Window | Split
Freeze Panes►View | Window | Freeze Panes
Currently Open Workbooks►View | Window | Switch Windows

MS Word 2003 -> 2007 Headers and Footers Toolbar

Posted on by Jeff Feiertag
Word 2003 Location Word 2007 Location
Insert AutoText►Insert | Headers & Footers | Footer
Insert AutoText►Insert | Headers & Footers | Header
Page Number►Insert | Headers & Footers | Page Number
Page Number►Header & Footer Tools | Design | Headers & Footer | Page Number
Number of Pages►Insert | Headers & Footers | Page Number
Number of Pages►Header & Footer Tools | Design | Headers & Footer | Page Number
Format Page Numbers►Insert | Header & Footer | Page Number | Format Page Numbers
Format Page Numbers►Header & Footer Tools | Design | Header & Footer | Page Number | Format Page Numbers
Date►Header & Footer Tools | Design | Insert | Date & Time
Time►Header & Footer Tools | Design | Insert | Date & Time
Page Setup►Page Layout | Page Setup | Page Setup
Hide Body Text►Office Button | Word Options | Customize | All Commands | Hide Body Text
Link to Previous►Header & Footer Tools | Design | Navigation | Link to Previous
Show Header/Footer►Office Button | Word Options | Customize | All Commands | Show Header/Footer
Previous Header►Header & Footer Tools | Design | Navigation | Previous Section
Next Header►Header & Footer Tools | Design | Navigation | Next Section
Close►Header & Footer Tools | Design | Close | Close Header and Footer

MS Word 2003 -> 2007 Table and Borders Toolbar

Posted on by Jeff Feiertag
Word 2003 Location Word 2007 Location
Draw Table►Table Tools | Design | Draw Borders | Draw Table
Draw Table►Home | Paragraph | Borders | Draw Table
Draw Table►Insert | Tables | Table | Draw Table
Draw Table►Table Tools | Design | Table Styles | Borders | Draw Table
Eraser►Table Tools | Design | Draw Borders | Eraser
Border Style►Table Tools | Design | Draw Borders | Pen Style
Border Width►Table Tools | Design | Draw Borders | Pen Weight
Border Color►Table Tools | Design | Draw Borders | Pen Color
Borders►Table Tools | Design | Table Styles | Borders
Shading Color►Table Tools | Design | Table Styles | Shading
Insert Table (Insert Table)►Insert | Tables | Table | Insert Table
Insert Table (Insert Columns to the Left)►Table Tools | Layout | Rows & Columns | Insert Left
Insert Table (Insert Columns to the Right)►Table Tools | Layout | Rows & Columns | Insert Left
Insert Table (Insert Rows Above)►Table Tools | Layout | Rows & Columns | Insert Above
Insert Table (Insert Rows Below)►Table Tools | Layout | Rows & Columns | Insert Below
Insert Table (Insert Cells)►Table Tools | Layout | Rows & Columns |
Dialog Box Launcher
Insert Table (AutoFit to Content)►Table Tools | Layout | Cell Size | AutoFit | AutoFit Contents
Insert Table (AutoFit to Window)►Table Tools | Layout | Cell Size | AutoFit | AutoFit Window
Insert Table (Fixed Column Width)►Table Tools | Layout | Cell Size | AutoFit | Fixed Column Width
Delete Columns►Table Tools | Layout | Rows & Columns | Delete | Delete Columns
Delete Rows►Table Tools | Layout | Rows & Columns | Delete | Delete Rows
Delete Cells►Table Tools | Layout | Rows & Columns | Delete | Delete Cells
AutoFit to Contents►Table Tools | Layout | Cell Size | AutoFit | AutoFit Contents
AutoFit to Window►Table Tools | Layout | Cell Size | AutoFit | AutoFit Window
Fixed Column Width►Table Tools | Layout | Cell Size | AutoFit | Fixed Column Width
Show/Hide Gridlines►Table Tools | Layout | Table | View/Hide Gridlines
Merge Cells►Table Tools | Layout | Merge | Merge Cells
Split Cells►Table Tools | Layout | Merge | Split Cells
Cell Alignment►Table Tools | Layout | Alignment
Distribute Rows Evenly►Table Tools | Layout | Cell Size | Distribute Rows
Distribute Columns Evenly►Table Tools | Layout | Cell Size | Distribute Columns
Table AutoFormat►Table Tools | Design | Table Styles
Change Text Direction►Table Tools | Layout | Alignment | Text Direction
Sort Ascending►Table Tools | Layout | Data | Sort
Sort Descending►Table Tools | Layout | Data | Sort
AutoSum►Table Tools | Layout | Data | Formula

MS Word 2003 -> 2007 Formatting Toolbar

Posted on by Jeff Feiertag
Word 2003 Location Word 2007 Location
Styles and Formatting►Home | Styles | Styles
Style►Home | Styles | Dialog Box Launcher
Font►Home | Font | Font
Font Size►Home | Font | Font Size
Bold►Home | Font | Bold
Italic►Home | Font | Italic
Underline►Home | Font | Underline
Align Left►Home | Paragraph | Align Left
Center►Home | Paragraph | Center
Align Right►Home | Paragraph | Align Right
Justify►Home | Paragraph | Justify
* Distributed►Home | Paragraph | Distributed
Line Spacing►Home | Paragraph | Line spacing
* Left-to-Right►Home | Paragraph | Left-to-Right
* Right-to-Left►Home | Paragraph | Right-to-Left
Numbering►Home | Paragraph | Numbering
Bullets►Home | Paragraph | Bullets
Decrease Indent►Home | Paragraph | Decrease Indent
Increase Indent►Home | Paragraph | Increase Indent
Borders►Home | Paragraph | Borders
Highlight►Home | Font | Highlight
Font Color►Home | Font | Font Color
Grow Font►Home | Font | Grow Font
Shrink Font►Home | Font | Shrink Font
Superscript►Home | Font | Superscript
Subscript►Home | Font | Subscript

MS Word 2003 -> 2007 Standard Toolbar

Posted on by Jeff Feiertag
Word 2003 Location Word 2007 Location
Spelling and Grammar►Review | Proofing | Spelling & Grammar
Format Painter►Home | Clipboard | Format Painter
Tables and Borders Toolbar►Insert or select a table to see the Table Tools tab
Insert Table►Insert | Tables | Table
Columns►Page Layout | Page Setup | Columns | More Columns
Find►Home | Editing | Find

MS Word 2003 -> 2007 Tools Menu

Posted on by Jeff Feiertag
Word 2003 Location Word 2007 Location
Spelling and Grammar►Review | Proofing | Spelling & Grammar
Word Count►Review | Proofing | Word Count
Track Changes►Review | Tracking | Track Changes
Compare and Merge Documents►Review | Compare | Compare | Compare
Compare and Merge Documents►Review | Compare | Compare | Combine
Letters and Mailings (Mail Merge)►Mailings | Start Mail Merge | Start Mail Merge | Step by Step Mail Merge Wizard
Letters and Mailings (Show Mail Merge Toolbar)►Toolbars have been removed from the product.
To find commands on the Mail Merge toolbar, go to the Mail Merge Toolbar sheet of this workbook.
Letters and Mailings (Envelopes and Labels)►Mailings | Create | Envelopes
Letters and Mailings (Envelopes and Labels)►Mailings | Create | Labels
AutoCorrect Options►Office Button | Word Options | Proofing | AutoCorrect Options
Options►Office Button | Word Options

MS Word 2003 -> 2007 Table Menu

Posted on by Jeff Feiertag
MS Word 2003 MS Word 2007
Draw Table►Table Tools | Design | Draw Borders | Draw Table
Draw Table►Home | Paragraph | Borders | Draw Table
Draw Table►Insert | Tables | Table | Draw Table
Draw Table►Table Tools | Design | Table Styles | Borders | Draw Table
Insert (Table)►Insert | Tables | Table | Insert Table
Insert (Columns to the Left)►Table Tools | Layout | Rows & Columns | Insert Left
Insert (Columns to the Right)►Table Tools | Layout | Rows & Columns | Insert Right
Insert (Rows Above)►Table Tools | Layout | Rows & Columns | Insert Above
Insert (Rows Below)►Table Tools | Layout | Rows & Columns | Insert Below
Insert (Cells)►Table Tools | Layout | Rows & Columns | Dialog Box Launcher
Delete (Table)►Table Tools | Layout | Rows & Columns | Delete | Delete Table
Delete (Columns)►Table Tools | Layout | Rows & Columns | Delete | Delete Columns
Delete (Rows)►Table Tools | Layout | Rows & Columns | Delete | Delete Rows
Delete (Cells)►Table Tools | Layout | Rows & Columns | Delete | Delete Cells
Select (Table)►Table Tools | Layout | Table | Select | Select Table
Select (Column)►Table Tools | Layout | Table | Select | Select Column
Select (Row)►Table Tools | Layout | Table | Select | Select Row
Select (Cell)►Table Tools | Layout | Table | Select | Select Cell
Merge Cells►Table Tools | Layout | Merge | Merge Cells
Split Cells►Table Tools | Layout | Merge | Split Cells
Split Table►Table Tools | Layout | Merge | Split Table
Table AutoFormat►Table Tools | Design | Table Styles
AutoFit (AutoFit to Contents)►Table Tools | Layout | Cell Size | AutoFit | AutoFit Contents
AutoFit (AutoFit to Window)►Table Tools | Layout | Cell Size | AutoFit | AutoFit Window
AutoFit (Fixed Column Width)►Table Tools | Layout | Cell Size | AutoFit | Fixed Column Width
AutoFit (Distribute Rows Evenly)►Table Tools | Layout | Cell Size | Distribute Rows
AutoFit (Distribute Columns Evenly)►Table Tools | Layout | Cell Size | Distribute Columns
Heading Rows Repeat►Table Tools | Layout | Data | Repeat Header Rows
Convert (Text to Table)►Insert | Tables | Table | Convert Text to Table
Convert (Table to Text)►Table Tools | Layout | Data | Convert to Text
Sort►Home | Paragraph | Sort
Sort►Table Tools | Layout | Data | Sort
Formula►Table Tools | Layout | Data | Formula
Show Gridlines►Table Tools | Layout | Table | Show Gridlines
Table Properties►Table Tools | Layout | Cell Size | Properties
Table Properties►Table Tools | Layout | Table | Properties
Insert (Columns to the Right)►Table Tools | Layout | Rows & Columns | Insert Right