Office

MS PowerPoint Edit

Posted on by Jeff Feiertag
PowerPoint 2003 Location PowerPoint 2007 Location
Undo►Quick Access Toolbar | Undo
Redo►Quick Access Toolbar | Redo
Cut►Home | Clipboard | Cut
Copy►Home | Clipboard | Copy
Paste►Home | Clipboard | Paste
Paste Special►Home | Clipboard | Paste | Paste Special
Clear►Press the DELETE key.
Select All►Home | Editing | Select | Select All
Duplicate►Home | Clipboard | Paste | Duplicate
Delete Slide►Home | Slides | Delete
Find►Home | Editing | Find
Replace►Home | Editing | Replace

MS Excel 2003 -> 2007 Chart

Posted on by Jeff Feiertag
Excel 2003 Location  Excel 2007 Location
Chart Objects►Chart Tools | Layout
Format Selected Object►Chart Tools | Format | Current Selection | Format Selection
Chart Type►Chart Tools | Design | Type | Change Chart Type
Legend►Chart Tools | Layout | Labels | Legend
Data Table►Chart Tools | Layout | Labels | Data Table
Series in Rows►Chart Tools | Design | Data | Switch Row/Column
Series in Columns►Chart Tools | Design | Data | Switch Row/Column
Angle Clockwise►Home | Alignment | Orientation | Angle Clockwise
Angle Counterclockwise►Home | Alignment | Orientation | Angle Counterclockwise

MS Excel 2003 -> 2007 Reviewing

Posted on by Jeff Feiertag
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

MS Excel 2003 -> 2007 Formula Auditing

Posted on by Jeff Feiertag
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

Posted on by Jeff Feiertag
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

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