Office

MS Excel 2003 -> 2007 Insert

Posted on by Jeff Feiertag
Excel 2003 Location  Excel 2007 Location
Cells►Home | Cells | Insert
Rows►Home | Cells | Insert | Insert Sheet Rows
Columns►Home | Cells | Insert | Insert Sheet Columns
Worksheet►Home | Cells | Insert | Insert Sheet
Chart►Insert | Charts
Symbol►Insert | Text | Symbol
Page Break►Page Layout | Page Setup | Breaks | Insert Page Break
Reset All Page Breaks►Page Layout | Page Setup | Breaks | Reset All Page Breaks
Picture | Clip Art►Insert | Illustrations | Clip Art
Picture | From File►Chart Tools | Layout | Insert | Picture
Picture | From File►PivotChart Tools | Layout | Insert | Picture
Picture | AutoShapes►Insert | Illustrations | Shapes
Picture | WordArt►Insert | Illustrations | WordArt
Hyperlink►Insert | Links | Hyperlink

MS Excel 2003 -> 2007 Format

Posted on by Jeff Feiertag
Excel 2003 Location  Excel 2007 Location
Cells►Home | Cells | Format | Format Cells
Row | Height►Home | Cells | Format | Row Height
Row | AutoFit►Home | Cells | Format | AutoFit Row Height
Row | Hide►Home | Cells | Format | Hide & Unhide | Hide Rows
Row | Unhide►Home | Cells | Format | Hide & Unhide | Unhide Rows
Column | Width►Home | Cells | Format | Column Width
Column | AutoFit Selection►Home | Cells | Format | AutoFit Column Width
Column | Hide►Home | Cells | Format | Hide & Unhide | Hide Columns
Column | Unhide►Home | Cells | Format | Hide & Unhide | Unhide Columns
Column | Standard Width►Home | Cells | Format | Default Width
Sheet | Rename►Home | Cells | Format | Rename Sheet
Sheet | Hide►Home | Cells | Format | Hide & Unhide | Hide Sheet
Sheet | Unhide►Home | Cells | Format | Hide & Unhide | Unhide Sheet
Sheet | Background►Page Layout | Page Setup | Background
Sheet | Tab Color►Home | Cells | Format | Tab Color
AutoFormat►Home | Styles | Format as Table
Conditional Formatting►Home | Conditional Formatting
Style►Home | Style | Cell Styles

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