| Excel 2003 Location | Excel 2007 Location | |
|---|---|---|
| New Comment | ► | Review | Comments | New Comment |
| Previous Comment | ► | Review | Comments | Previous |
| Next Comment | ► | Review | Comments | Next |
| Show/Hide Comments | ► | Review | Comments | Show/Hide Comment |
| Hide All Comments | ► | Review | Comments | Hide All Comments |
| Show All Comments | ► | Review | Comments | Show All Comments |
| Delete Comment | ► | Review | Comments | Delete |
| Insert Ink Annotations | ► | Review | Ink | Start Inking |
| Hide Ink Annotations | ► | Review | Comments | Show Ink |
| Delete All Ink Annotations | ► | Ink Tools | Pens | Select | Delete All Ink |
| Reply with Changes | ► | Office Button | Excel Options | Customize | All Commands | Reply with Changes |
Excel Upgrade
MS Excel 2003 -> 2007 Formula Auditing
| Excel 2003 Location | Excel 2007 Location | |
|---|---|---|
| Error Checking | ► | Formulas | Formula Auditing | Error Checking |
| Trace Precedents | ► | Formulas | Formula Auditing | Trace Precedents |
| Remove Precedent Arrows | ► | Formulas | Formula Auditing | Remove Arrows | Remove Precedent Arrows |
| Trace Dependents | ► | Formulas | Formula Auditing | Trace Dependents |
| Remove Dependent Arrows | ► | Formulas | Formula Auditing | Remove Arrows | Remove Dependent Arrows |
| Remove All Arrows | ► | Formulas | Formula Auditing | Remove Arrows |
| Trace Error | ► | Formulas | Formula Auditing | Error Checking | Trace Error |
| New Comment | ► | Review | Comments | New Comment |
| Circle Invalid Data | ► | Data | Data Tools | Data Validation | Circle Invalid Data |
| Clear Validation Circles | ► | Data | Data Tools | Data Validation | Clear Validation Circles |
| Show Watch Window | ► | Formulas | Formula Auditing | Watch Window |
| Evaluate Formula | ► | Formulas | Formula Auditing | Evaluate Formula |
MS Excel 2003 -> 2007 Borders
| Excel 2003 Location | Excel 2007 Location | |
|---|---|---|
| Draw Border | Draw Border | ► | Home | Font | Borders | Draw Border |
| Draw Border | Draw Border Grid | ► | Home | Font | Borders | Draw Border Grid |
| Erase Border | ► | Home | Font | Borders | Erase Border |
| Line Style | ► | Home | Font | Borders | Line Style |
| Line Color | ► | Home | Font | Borders | Line Color |
MS Excel 2003 -> 2007 Protection
| 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
| 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
| 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 |
| ► | Office Button | Print | |
| Most Recently Used Documents | ► | Office Button | Most Recently Used Documents |
MS Excel 2003 -> 2007 Edit
| 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
| 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
| 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
| 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 |