2007

MS Excel 2003 -> 2007 Protection

Posted on by Jeff Feiertag
Excel 2003 Location  Excel 2007 Location
Lock Cell►Home | Cells | Format | Lock Cell
Allow Users to Edit Ranges►Review | Changes | Allow Users to Edit Ranges
Protect Sheet►Review | Changes | Protect Sheet
Protect Sheet►Home | Cells | Format | Protect Sheet
Protect Workbook►Review | Changes | Protect Workbook
Protect and Share Workbook►Review | Changes | Protect and Share Workbook

MS Excel 2003 -> 2007 Diagram

Posted on by Jeff Feiertag
Excel 2003 Location  Excel 2007 Location
Insert Shape►Smart Art Tools | Design | Create Graphic | Add Shape
Move Shape Backward►SmartArt Tools | Format | Arrange | Send to Back | Send Backward
Move Shape Forward►SmartArt Tools | Format | Arrange | Bring to Front | Bring Forward
Reverse Diagram►SmartArt Tools | Design | Create Graphic | Right to Left
Layout | Fit Diagram to Contents►Click to resize and drag any corner of the diagram until you achive desired size.
Layout | Expand Diagram►SmartArt Tools | Format | Size
Layout | Resize Diagram►Select the diagram and click and drag any corner of the diagram's border until you achieve the desired size.
Layout | AutoLayout►SmartArt Tools | Design | Layouts
AutoFormat►SmartArt Tools | Design | Styles
Change to | Cycle►SmartArt Tools | Design | Layouts | More Layouts
Change to | Radial►SmartArt Tools | Design | Layouts | More Layouts
Change to | Pyramid►SmartArt Tools | Design | Layouts | More Layouts
Change to | Venn►SmartArt Tools | Design | Layouts | More Layouts
Change to | Target►SmartArt Tools | Design | Layouts | More Layouts

MS Excel 2003 -> 2007 File

Posted on by Jeff Feiertag
Excel 2003 Location  Excel 2007 Location
File►Office Button
New►Office Button | New
Open►Office Button | Open
Close►Office Button | Close
Save►Quick Access Toolbar | Save
Save►Office Button | Save
Save As►Office Button | Save As
Save Workspace►View | Window | Save Workspace
Page Setup►Page Layout | Page Setup | Dialog Launcher
Print Area | Set Print Area►Page Layout | Page Setup | Print Area | Set Print Area
Print Area | Clear Print Area►Page Layout | Page Setup | Print Area | Clear Print Area
Print Preview►Office Button | Print | Print Preview
Print►Office Button | Print
Most Recently Used Documents►Office Button | Most Recently Used Documents

MS Excel 2003 -> 2007 Edit

Posted on by Jeff Feiertag
Excel 2003 Location  Excel 2007 Location
Undo►Quick Access Toolbar | Undo
Redo►Quick Access Toolbar | Redo
Cut►Home | Clipboard | Cut
Copy►Home | Clipboard | Copy
Office Clipboard►Home | Clipboard | Office Clipboard
Paste►Home | Clipboard | Paste
Paste Special►Home | Clipboard | Paste | Paste Special
Paste as Hyperlink►Home | Clipboard | Paste | Paste as Hyperlink
Fill | Down►Home | Editing | Fill | Down
Fill | Right►Home | Editing | Fill | Right
Fill | Up►Home | Editing | Fill | Up
Fill | Left►Home | Editing | Fill | Left
Fill | Across Worksheets►Home | Editing | Fill | Across Worksheets
Fill | Series►Home | Editing | Fill | Series
Fill | Justify►Home | Editing | Fill | Justify
Clear | All►Home | Editing | Clear | Clear All
Clear | Formats►Home | Editing | Clear | Clear Formats
Clear | Contents►Home | Editing | Clear | Clear Contents
Clear | Comments►Home | Editing | Clear | Clear Comments
Delete►Home | Cells | Delete
Delete Sheet►Home | Cells | Delete | Delete Sheet
Move or Copy Sheet►Home | Cells | Format | Move or Copy Sheet
Find►Home | Editing | Find & Select | Find
Replace►Home | Editing | Find & Select | Replace
Go To►Home | Editing | Find & Select | Go To
Links►Office Button | Prepare | Edit Links to Office Buttons
Object►Double-click an object to edit it.

MS Excel 2003 -> 2007 View

Posted on by Jeff Feiertag
Excel 2003 Location  Excel 2007 Location
Normal►View | Workbook Views | Normal
Page Break Preview►View | Workbook Views | Page Break Preview
Task Pane►In some groups, dialog box launchers will display a Task Pane instead of a dialog box. For example, Home | Clipboard | Dialog Launcher
Formula Bar►View | Show/Hide | Formula Bar
Status Bar►Status Bar is always visible by default.
Header and Footer►Insert | Text | Header & Footer
Comments►Review | Comments | Show All Comments
Zoom►View | Zoom | Zoom

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