Locations of Excel 2003 Commands in Excel 2007

Reference: Locations of Excel 2003 commands in Excel 2007
Tips for using this workbook

1. The order of the worksheets matches the order of the default user interface (UI). If you prefer,
rearrange the worksheets so that the menus and toolbars that you use most often are on the leftmost
side of the workbook.
2. The names of the worksheet tabs match the menu and toolbar names in Excel 2003.
3. To search for a specific command in this workbook, do one of the following:

• In Excel 2003, on the Edit menu, click Find.
• In Excel 2007, on the Home tab, in the Editing group, click Find & Select, and then click Find.
4. To print, do one of the following:

• In Excel 2003, on the File menu, click Print. Under Print what, select an option to print the selection,
the active sheet(s), or the entire workbook.
• In Excel 2007, click the Microsoft Office Button

and then click Print. Under Print what, select an option to print the selection, the active sheet(s), or the
entire workbook.
5. Commands that are preceded by an asterisk (*) are available only when the language that uses the
command has been enabled for editing text.
Excel: Standard
Excel 2003 Location Excel 2007 Location
New > Office Button | New | Blank Worksheet
Open > Office Button | Open
Save > Quick Access Toolbar | Save
Save > Office Button | Save
Permission > Office Button | Prepare | Restrict Permission | Restrict Permission As
Email > Office Button | Send | Email
Print > Office Button | Print | Quick Print
Print Preview > Office Button | Print | Print Preview
Spelling > Review | Proofing | Spelling
Research > Review | Proofing | Research
Cut > Home | Clipboard | Cut
Copy > Home | Clipboard | Copy
Paste > Home | Clipboard | Paste
Format Painter > Home | Clipboard | Format Painter
Undo > Quick Access Toolbar | Undo
Redo > Quick Access Toolbar | Redo
Ink Annotations > Review | Ink | Start Inking
Hyperlink > Insert | Links | Hyperlink
AutoSum > Home | Editing | AutoSum
AutoSum > Formulas | Function Library | AutoSum
Sort Ascending > Data | Sort & Filter | Sort A to Z
Sort Descending > Data | Sort & Filter | Sort Z to A
Chart Wizard > Insert | Charts

These commands are available in the Drawing Tools tabs when you insert or
Drawing >
select a shape.
View | Zoom | Zoom
Zoom >
Status Bar | Zoom Slider
Microsoft Excel Help > Upper Ribbon | Help
PivotTable and PivotChart Insert | Tables | PivotTable | PivotTable
>
Report Insert | Tables | PivotTable | PivotChart
Comment > Review | Comments | New Comment
Home | Editing | Sort & Filter | Filter
AutoFilter >
Data | Sort & Filter | Filter
Excel: Formatting
Font > Home | Font | Font
Font Size > Home | Font | Font Size
Bold > Home | Font | Bold
Italic > Home | Font | Italic
Underline > Home | Font | Underline | Underline
Align Left > Home | Alignment | Align Left
Center > Home | Alignment | Center
Align Right > Home | Alignment | Align Right
Merge and Center > Home | Alignment | Merge & Center
Merge and Center > Home | Alignment | Merge | Merge & Center
Currency Style > Home | Number | Accounting Number Format
Percent Style > Home | Number | Percent Style
Comma Style > Home | Number | Comma Style
Increase Decimal > Home | Number | Increase Decimal
Decrease Decimal > Home | Number | Decrease Decimal
Decrease Indent > Home | Alignment | Decrease Indent
Increase Indent > Home | Alignment | Increase Indent
Borders > Home | Font | Borders
Fill Color > Home | Font | Fill Color
Font Color > Home | Font | Font Color
Chart | Chart Type > Chart Tools | Design | Type | Change Chart Type
Chart | Source Data > Chart Tools | Design | Data | Select Data
Chart | Source Data > PivotChart Tools | Design | Data | Select Data
Chart | Chart Options > Chart | Layout
Chart | Location > Chart Tools | Design | Location | Move Chart
Chart | Location > PivotChart Tools | Design | Location | Move Chart
Chart | Add Data > Chart Tools | Design | Data | Edit Data Source
Chart | Add Trendline > Chart Tools | Layout | Analysis | Trendline
Chart | 3-D View > Chart Tools | Layout | Background | 3-D View
AutoFormat > Home | Styles | Format as Table
Cells > Home | Cells | Format | Format Cells
Increase Font Size > Home | Font | Increase Font Size
Decrease Font Size > Home | Font | Decrease Font Size
Text Direction > Home | Alignment | Orientation

Excel: PivotTable
PivotTable | Format Report > Pivot Table Tools | Design| PivotTable Styles
PivotTable | PivotChart > PivotTable Tools | Options | Tools | PivotChart
PivotTable | PivotTable Office Button | Excel Options | Customize | All Commands |
>
Wizard PivotTable and PivotChart Wizard
PivotTable | Refresh Data > PivotChart Tools | Analyze | Data | Refresh
PivotTable | Refresh Data > PivotTable Tools | Options | Data | Refresh
PivotTable | Offline OLAP > PivotTable Tools | Options | Tools | OLAP tools | Offline OLAP
PivotTable | Hide
> Row/Column Context Menu | Delete
Dimension
PivotTable | Select | Label > PivotTable Tools | Options | Actions | Select | Label
PivotTable | Select | Data > PivotTable Tools | Options | Actions | Select | Data
PivotTable | Select | Label
> PivotTable Tools | Options | Actions | Select | Label and Data
and Data
PivotTable | Select | Entire
> PivotTable Tools | Options | Actions | Select | Entire Table
Table
PivotTable | Select |
> PivotTable Tools | Options | Actions | Select | Enable Selection
Enable Selection
PivotTable | Group and
> PivotTable Tools | Options | Active Field | Collapse Entire Field
Show Detail | Hide Detail
> PivotTable Tools | Options | Active Field | Expand Entire Field
Show Detail | Show Detail
> PivotTable Tools | Options | Group | Group Selection
Show Detail | Group
> PivotTable Tools | Options | Group | Ungroup
Show Detail | Ungroup
PivotTable | Formulas |
> PivotTable Tools | Options | Tools | Formulas | Calculated Field
Calculated Field
> PivotTable Tools | Options | Tools | Formulas | Calculated Item
Calculated Item
> PivotTable Tools | Options | Tools | Formulas | Solve Order
Solve Order
> PivotTable Tools | Options | Tools | Formulas | List Formulas
List Formulas
PivotTable | Order | Move
> PivotTable Cell Right Click Menu | Move | Move to Beginning
to Beginning
> PivotTable Cell Right Click Menu | Move | Move Up
Up
> PivotTable Cell Right Click Menu | Move | Move Down
Down
> PivotTable Cell Right Click Menu | Move | Move to End
to End
> PivotTable Cell Right Click Menu | Move | Move to Columns
to Column
PivotTable | Field Settings > PivotTable Tools | Options | Active Field | Field Settings
PivotTable | Subtotals > PivotTable Tools | Design | Layout | Subtotals
PivotTable | Sort and Top
> PivotTable Tools | Options |Sort
10
PivotTable | Property
> PivotTable Tools | Options | Tools | OLAP tools | Property Fields
Fields
PivotTable | Table Options > PivotTable Tools | Options | PivotTable | Options
PivotTable Tools | Options | PivotTable | Options | Show Report
PivotTable | Show Pages >
Filter Pages
PivotChart | Field Settings > PivotTable Tools | Options | Active Field | Field Settings
PivotChart | Options > PivotTable Tools | Options | PivotTable | Options
PivotChart | Refresh Data > PivotChart Tools | Analyze | Data | Refresh
PivotChart | Formulas |
> PivotTable Tools | Options | Tools | Formulas | Calculated Field
Calculated Field
> PivotTable Tools | Options | Tools | Formulas | Calculated Item
Calculated Item
> PivotTable Tools | Options | Tools | Formulas | Solve Order
Solve Order
> PivotTable Tools | Options | Tools | Formulas | List Formulas
List Formulas
Click the PivotChart, and then in the PivotTable Field List, clear
PivotChart | Remove Field >
any field checkbox.
Format Report > Pivot Table | Design | PivotTable Styles
Office Button | Excel Options | Customize | All Commands |
Chart Wizard >
PivotTable and PivotChart Wizard
Hide Detail > PivotTable Tools | Options | Active Field | Collapse Entire Field
Show Detail > PivotTable Tools | Options | Active Field | Expand Entire Field
Refresh Data > PivotTable Tools | Options | Data | Refresh
Field Settings > PivotTable Tools | Options | Active Field | Field Settings
Show Field List > PivotTable Tools | Options | Show/Hide | Field List
Ungroup > PivotTable Tools | Options | Group | Ungroup
Group > PivotTable Tools | Options | Group | Group Selection
PivotTable and PivotChart Office Button | Excel Options | Customize | All Commands |
>
Report PivotTable and PivotChart Wizard
PivotTable Tools | Options | PivotTable | Options | Show Report
Show Pages >
Filter Pages
Refresh All > PivotTable Tools | Options | Data | Refresh | Refresh All
PivotTable Tools | Options | PivotTable | Options | Generate
Generate GetPivotData >
GetPivotData
Property Fields > PivotTable Tools | Options | Tools | OLAP tools | Property Fields
Sort and Top 10 > PivotTable Tools | Options |Sort

Offline OLAP > PivotTable Tools | Options | Tools | OLAP tools | Offline OLAP
Excel: Chart (Toolbar)
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
Excel: Reviewing
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
Create Microsoft Office Office Button | Excel Options | Customize | All Commands | Create Microsoft
>
Outlook Task Office Outlook Task
Update File > Office Button | Excel Options | Customize | All Commands | Update File
Mail Recipient (as
> Office Button | Send | E-mail
Attachment)
Reply with Changes > Office Button | Excel Options | Customize | All Commands | Reply with Changes
End Review > Office Button | Excel Options | Customize | All Commands | End Review
Excel: Forms
Label > Developer | Controls | Insert | Label (Form Control)
Edit Box > Developer | Controls | Insert | Edit Box (Form Control)
Group Box > Developer | Controls | Insert | Group Box (Form Control)
Button > Developer | Controls | Insert | Button (Form Control)
Check Box > Developer | Controls | Insert | Check Box (Form Control)
Option Button > Developer | Controls | Insert | Option Button (Form Control)
List Box > Developer | Controls | Insert | List Box (Form Control)
Combo Box > Developer | Controls | Insert | Combo Box(Form Control)
Combination List-Edit > Developer | Controls | Insert | Combination List-Edit (Form Control)
Combination Drop-Down
> Developer | Controls | Insert | Combination Drop-Down Edit (Form Control)
Edit
Scroll Bar > Developer | Controls | Insert | Scroll Bar (Form Control)
Spinner > Developer | Controls | Insert | Spinner (Form Control)
Control Properties > Developer | Controls | Properties
Edit Code > Developer | Controls | View Code
Toggle Grid > View | Show/Hide | Gridlines
Toggle Grid > Page Layout | Sheet Options | Gridlines | View
Run Dialog > Developer | Controls | Run Dialog
Excel: Stop Recording
Record New Macro > Developer | Code | Record Macro
Record New Macro > View | Macros | Macros | Record Macro
Relative Reference > Developer | Code | Use Relative References
Relative Reference > View | Macros | Macros | Use Relative References
Excel: External Data
Edit Query > Office Button | Excel Options | Customize | All Commands | Edit Query
Data Range Properties > Data | Connections | Properties
Data Range Properties > Table Tools | Design | External Table Data | Properties
Query Parameters > Office Button | Excel Options | Customize | All Commands | Parameters
Refresh Data > PivotChart Tools | Analyze | Data | Refresh
Refresh Data > Table Tools | Design | External Table Data | Refresh
Refresh Data > Data | Connections | Refresh | Refresh
Cancel Refresh > Data | Connections | Refresh | Cancel Refresh
Cancel Refresh > PivotChart Tools | Analyze | Data | Refresh | Cancel Refresh
Cancel Refresh > PivotTable Tools | Options | Data | Refresh | Cancel Refresh
Cancel Refresh > Table Tools | Design | External Table Data | Refresh | Cancel Refresh
Refresh All > Data | Connections | Refresh All
Refresh All > PivotChart Tools | Analyze | Data | Refresh | Refresh All
Refresh All > PivotTable Tools | Options | Data | Refresh | Refresh All
Refresh All > Table Tools | Design | External Table Data | Refresh | Refresh All
Refresh Status > Data | Connections | Refresh | Refresh Status
Refresh Status > PivotChart Tools | Analyze | Data | Refresh | Refresh Status
Refresh Status > PivotTable Tools | Options | Data | Refresh | Refresh Status
Refresh Status > Table Tools | Design | External Table Data | Refresh | Refresh Status
Excel: Formula Auditing
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
> Formulas | Formula Auditing | Remove Arrows | Remove Dependent Arrows
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
Excel: Full Screen
Full Screen > View | Workbook Views | Full Screen
Excel: Circular Reference
Navigate Circular
> Formulas | Formula Auditing | Error Checking | Circular References
Reference
Trace Dependents > Formulas | Formula Auditing | Trace Dependents
Trace Precedents > Formulas | Formula Auditing | Trace Precedents
Remove All Arrows > Formulas | Formula Auditing | Remove Arrows
Remove All Arrows > Formulas | Formula Auditing | Remove Arrows | Remove Arrows
Excel: Visual Basic
Run Macros > Developer | Code | Macros
Macros > View | Macros | Macros
Record New Macro > Developer | Code | Record Macro
Record New Macro > View | Macros | Macros | Record Macro
Security > Developer | Code | Macro Security
Visual Basic Editor > Developer | Code | Visual Basic
Control Toolbox > Developer | Controls
Design Mode > Developer | Controls | Design Mode
Excel: Web
Back > Office Button | Excel Options | Customize | All Commands | Back
Forward > Office Button | Excel Options | Customize | All Commands | Forward
Stop > Removed from product
Refresh > Removed from product
Start Page > Removed from product
Search the Web > Removed from product
Favorites | Add to
> Removed from product
Favorites
Favorites | Open Favorites > Removed from product
Go | Back > Office Button | Excel Options | Customize | All Commands | Back
Go | Forward > Office Button | Excel Options | Customize | All Commands | Forward
Go | Start Page > Removed from product
Go | Search the Web > Removed from product
Go | Set Start Page > Removed from product
Go | Set Search Page > Removed from product
Show Only Web Toolbar > Removed from product
Address > Removed from product
*Address > Office Button | Excel Options | Customize | All Commands | Document Location
Excel: Control Toolbox
Properties > Developer | Controls | Properties
View Code > Developer | Controls | View Code
Check Box > Developer | Controls | Insert | Check Box
Text Box > Developer | Controls | Insert | Text Box
Command Button > Developer | Controls | Insert | Command Button
Option Button > Developer | Controls | Insert | Option Button
List Box > Developer | Controls | Insert | List Box
Combo Box > Developer | Controls | Insert | Combo Box
Toggle Button > Developer | Controls | Insert | Toggle Button
Spin Button > Developer | Controls | Insert | Spin Button
Scroll Bar > Developer | Controls | Insert | Scroll Bar
Label > Developer | Controls | Insert | Label
Image > Developer | Controls | Insert | Image
More Controls > Developer | Controls | Insert | More Controls
Excel: Exit Design Mode
Excel: Watch Window
Watch Window > Formulas | Formula Auditing | Watch Window
Excel: Borders
Draw Border | Draw Border > Home | Font | Borders | Draw Border
Draw Border | Draw Border

> Home | Font | Borders | Draw Border Grid
Grid
Erase Border > Home | Font | Borders | Erase Border
Line Style > Home | Font | Borders | Line Style
Line Color > Home | Font | Borders | Line Color
Excel: Protection
Lock Cell > Home | Cells | Format | Lock Cell
Allow Users to Edit
> Review | Changes | Allow Users to Edit Ranges
Ranges
Protect Sheet > Review | Changes | Protect Sheet
Protect Sheet > Home | Cells | Format | Protect Sheet
Protect Workbook > Review | Changes | Protect Workbook
Protect and Share
> Review | Changes | Protect and Share Workbook
Workbook
Excel: Text to Speech
Speak Cells > Office Button | Excel Options | Customize | All Commands | Speak Cells
Office Button | Excel Options | Customize | All Commands | Speak Cells - Stop
Stop Speaking >
Speaking Cells
Office Button | Excel Options | Customize | All Commands | Speak Cells By
By Rows >
Rows
Office Button | Excel Options | Customize | All Commands | Speak Cells By
By Columns >
Columns
Office Button | Excel Options | Customize | All Commands | Speak Cells On
Speak On Enter >
Enter
Excel: List
List | Insert | Row > Home | Cells | Insert | Insert Table Rows Above
List | Insert | Column > Home | Cells | Insert | Insert Table Columns to the Left
List | Delete | Row > Home | Cells | Delete | Delete Table Rows
List | Delete | Column > Home | Cells | Delete | Delete Table Columns
List | Sort > Home | Editing | Sort & Filter
List | Form > Office Button | Excel Options | Customize | All Commands | Form
List | Publish List > Table Tools | Design | External Table Data | Export | Export Table to SharePoint List
List | Resize List > Table Tools | Design | Properties | Resize Table
List | View List on Server > Table Tools | Design | External Table Data | Open in Browser
List | Convert to Range > Table Tools | Design | Tools | Convert to Range
List | Unlink List > Table Tools | Design | External Table Data | Unlink
List | Data Range
> Table Tools | Design | External Table Data | Properties
Properties
Toggle Total Row > Table Tools | Design | Table Style Options | Total Row
Synchronize List > Office Button | Excel Options | Customize | All Commands | Synchronize List
Discard Changes and Office Button | Excel Options | Customize | All Commands | Discard Changes and
>
Refresh Refresh
Refresh XML Data > Developer | XML | Refresh Data
Import XML Data > Developer | XML | Import
Export XML Data > Developer | XML | Export
XML Map Properties > Developer | XML | Map Properties
Edit Query > Removed from product
Chart Wizard > Insert | Charts
Print List > Office Button | Excel Options | Customize | All Commands | Print List
Excel: Compare Side by Side
Synchronous Scrolling > View | Window | Synchronous Scrolling
Reset Window Position > View | Window | Reset Window Position
Compare Side by Side with > View | Window | View Side by Side
Excel: Drawing
Draw | Group > Page Layout | Arrange | Group | Group
Draw | Group > Drawing Tools | Format | Arrange | Group | Group
Draw | Group > Chart Tools | Format | Arrange | Group | Group
Draw | Group > PivotChart Tools | Format | Arrange | Group | Group
Draw | Group > SmartArt Tools | Format | Arrange | Group | Group
Draw | Group > Picture Tools | Format | Arrange | Group | Group
Draw | Ungroup > Page Layout | Arrange | Group | Ungroup
Draw | Ungroup > Drawing Tools | Format | Arrange | Group | Ungroup
Draw | Ungroup > Chart Tools | Format | Arrange | Group | Ungroup
Draw | Ungroup > PivotChart Tools | Format | Arrange | Group | Ungroup
Draw | Ungroup > SmartArt Tools | Format | Arrange | Group | Ungroup
Draw | Ungroup > Picture Tools | Format | Arrange | Group | Ungroup
Draw | Regroup > Page Layout | Arrange | Group | Regroup
Draw | Regroup > Drawing Tools | Format | Arrange | Group | Regroup
Draw | Regroup > Chart Tools | Format | Arrange | Group | Regroup
Draw | Regroup > PivotChart Tools | Format | Arrange | Group | Regroup
Draw | Regroup > SmartArt Tools | Format | Arrange | Group | Regroup
Draw | Regroup > Picture Tools | Format | Arrange | Group | Regroup
Draw | Order | Bring to
> Page Layout | Arrange | Bring to Front
Front
> Drawing Tools | Format | Arrange | Bring to Front
Front
> Chart Tools | Format | Arrange | Bring to Front
Front
> PivotChart Tools | Format | Arrange | Bring to Front
Front
> SmartArt Tools | Format | Arrange | Bring to Front
Front
> Picture Tools | Format | Arrange | Bring to Front
Front
Draw | Order | Send to
> Page Layout | Arrange | Send to Back
Back
> Drawing Tools | Format | Arrange | Send to Back
Back
> Chart Tools | Format | Arrange | Send to Back
Back
> PivotChart Tools | Format | Arrange | Send to Back
Back
> SmartArt Tools | Format | Arrange | Send to Back
Back
> Picture Tools | Format | Arrange | Send to Back
Back
Draw | Order | Bring
> Page Layout | Arrange | Bring to Front | Bring Forward
Forward
> Drawing Tools | Format | Arrange | Bring to Front | Bring Forward
Forward
> Chart Tools | Format | Arrange | Bring to Front | Bring Forward
Forward
> PivotChart Tools | Format | Arrange | Bring to Front | Bring Forward
Forward
> SmartArt Tools | Format | Arrange | Bring to Front | Bring Forward
Forward
> Picture Tools | Format | Arrange | Bring to Front | Bring Forward
Forward
Draw | Order | Send
> Page Layout | Arrange | Send to Back | Send Backward
Backward
Draw | Order | Send
> Drawing Tools | Format | Arrange | Send to Back | Send Backward
Backward
Draw | Order | Send
> Chart Tools | Format | Arrange | Send to Back | Send Backward
Backward
Draw | Order | Send
> PivotChart Tools | Format | Arrange | Send to Back | Send Backward
Backward
Draw | Order | Send
> SmartArt Tools | Format | Arrange | Send to Back | Send Backward
Backward
Draw | Order | Send
> Picture Tools | Format | Arrange | Send to Back | Send Backward
Backward
Draw | Snap | To Grid > Page Layout | Arrange | Align | Snap to Grid
Draw | Snap | To Grid > Drawing Tools | Format | Arrange | Align | Snap to Grid
Draw | Snap | To Grid > Chart Tools | Format | Arrange | Align | Snap to Grid
Draw | Snap | To Grid > PivotChart Tools | Format | Arrange | Align | Snap to Grid
Draw | Snap | To Grid > SmartArt Tools | Format | Arrange | Align | Snap to Grid
Draw | Snap | To Grid > Picture Tools | Format | Arrange | Align | Snap to Grid
Draw | Snap | To Shape > Page Layout | Arrange | Align | Snap to Shape
Draw | Snap | To Shape > Drawing Tools | Format | Arrange | Align | Snap to Shape
Draw | Snap | To Shape > Chart Tools | Format | Arrange | Align | Snap to Shape
Draw | Snap | To Shape > PivotChart Tools | Format | Arrange | Align | Snap to Shape
Draw | Snap | To Shape > SmartArt Tools | Format | Arrange | Align | Snap to Shape
Draw | Snap | To Shape > Picture Tools | Format | Arrange | Align | Snap to Shape
Draw | Nudge | Up > Office Button | Excel Options | Customize | All Commands | Up
Draw | Nudge | Down > Office Button | Excel Options | Customize | All Commands | Down
Draw | Nudge | Left > Office Button | Excel Options | Customize | All Commands | Left
Draw | Nudge | Right > Office Button | Excel Options | Customize | All Commands | Right
Draw | Align or Distribute |
> Page Layout | Arrange | Align | Align Left
Align Left
> Drawing Tools | Format | Arrange | Align | Align Left
Align Left
> Chart Tools | Format | Arrange | Align | Align Left
Align Left
> PivotChart Tools | Format | Arrange | Align | Align Left
Align Left
> SmartArt Tools | Format | Arrange | Align | Align Left
Align Left
> Picture Tools | Format | Arrange | Align | Align Left
Align Left
> Page Layout | Arrange | Align | Align Center
Align Center
> Drawing Tools | Format | Arrange | Align | Align Center
Align Center
> Chart Tools | Format | Arrange | Align | Align Center
Align Center
> PivotChart Tools | Format | Arrange | Align | Align Center
Align Center
> SmartArt Tools | Format | Arrange | Align | Align Center
Align Center
> Picture Tools | Format | Arrange | Align | Align Center
Align Center
> Page Layout | Arrange | Align | Align Right
Align Right
> Drawing Tools | Format | Arrange | Align | Align Right
Align Right
> Chart Tools | Format | Arrange | Align | Align Right
Align Right
> PivotChart Tools | Format | Arrange | Align | Align Right
Align Right
> SmartArt Tools | Format | Arrange | Align | Align Right
Align Right
> Picture Tools | Format | Arrange | Align | Align Right
Align Right
> Page Layout | Arrange | Align | Align Top
Align Top
> Drawing Tools | Format | Arrange | Align | Align Top
Align Top
> Chart Tools | Format | Arrange | Align | Align Top
Align Top
> PivotChart Tools | Format | Arrange | Align | Align Top
Align Top
> SmartArt Tools | Format | Arrange | Align | Align Top
Align Top
> Picture Tools | Format | Arrange | Align | Align Top
Align Top
> Page Layout | Arrange | Align | Align Middle
Align Middle
> Drawing Tools | Format | Arrange | Align | Align Middle
Align Middle
> Chart Tools | Format | Arrange | Align | Align Middle
Align Middle
> PivotChart Tools | Format | Arrange | Align | Align Middle
Align Middle
> SmartArt Tools | Format | Arrange | Align | Align Middle
Align Middle
> Picture Tools | Format | Arrange | Align | Align Middle
Align Middle
> Page Layout | Arrange | Align | Align Bottom
Align Bottom
> Drawing Tools | Format | Arrange | Align | Align Bottom
Align Bottom
> Chart Tools | Format | Arrange | Align | Align Bottom
Align Bottom
> PivotChart Tools | Format | Arrange | Align | Align Bottom
Align Bottom
> SmartArt Tools | Format | Arrange | Align | Align Bottom
Align Bottom
> Picture Tools | Format | Arrange | Align | Align Bottom
Align Bottom
> Page Layout | Arrange | Align | Distribute Horizontally
Distribute Horizontally
> Drawing Tools | Format | Arrange | Align | Distribute Horizontally
> Chart Tools | Format | Arrange | Align | Distribute Horizontally
> PivotChart Tools | Format | Arrange | Align | Distribute Horizontally
> SmartArt Tools | Format | Arrange | Align | Distribute Horizontally
> Picture Tools | Format | Arrange | Align | Distribute Horizontally
> Page Layout | Arrange | Align | Distribute Vertically
Distribute Vertically
> Drawing Tools | Format | Arrange | Align | Distribute Vertically
> Chart Tools | Format | Arrange | Align | Distribute Vertically
> PivotChart Tools | Format | Arrange | Align | Distribute Vertically
> SmartArt Tools | Format | Arrange | Align | Distribute Vertically
> Picture Tools | Format | Arrange | Align | Distribute Vertically
Draw | Rotate or Flip | Free
> Click object, select green anchor, and drag around to rotate freely
Rotate
Draw | Rotate or Flip |
> Page Layout | Arrange | Rotate | Rotate Left 90°
Rotate Left 90
> Drawing Tools | Format | Arrange | Rotate | Rotate Left 90°
Rotate Left 90
> Chart Tools | Format | Arrange | Rotate | Rotate Left 90°
Rotate Left 90
> PivotChart Tools | Format | Arrange | Rotate | Rotate Left 90°
Rotate Left 90
> SmartArt Tools | Format | Arrange | Rotate | Rotate Left 90°
Rotate Left 90
> Picture Tools | Format | Arrange | Rotate | Rotate Left 90°
Rotate Left 90
> Page Layout | Arrange | Rotate | Rotate Right 90°
Rotate Right 90
> Drawing Tools | Format | Arrange | Rotate | Rotate Right 90°
Rotate Right 90
> Chart Tools | Format | Arrange | Rotate | Rotate Right 90°
Rotate Right 90
> PivotChart Tools | Format | Arrange | Rotate | Rotate Right 90°
Rotate Right 90
> SmartArt Tools | Format | Arrange | Rotate | Rotate Right 90°
Rotate Right 90
> Picture Tools | Format | Arrange | Rotate | Rotate Right 90°
Rotate Right 90
Draw | Rotate or Flip | Flip
> Page Layout | Arrange | Rotate | Flip Horizontal
Horizontal
> Drawing Tools | Format | Arrange | Rotate | Flip Horizontal
Horizontal
> Chart Tools | Format | Arrange | Rotate | Flip Horizontal
Horizontal
> PivotChart Tools | Format | Arrange | Rotate | Flip Horizontal
Horizontal
> SmartArt Tools | Format | Arrange | Rotate | Flip Horizontal
Horizontal
> Picture Tools | Format | Arrange | Rotate | Flip Horizontal
Horizontal
> Page Layout | Arrange | Rotate | Flip Vertical
Vertical
> Drawing Tools | Format | Arrange | Rotate | Flip Vertical
Vertical
> Chart Tools | Format | Arrange | Rotate | Flip Vertical
Vertical
> PivotChart Tools | Format | Arrange | Rotate | Flip Vertical
Vertical
> SmartArt Tools | Format | Arrange | Rotate | Flip Vertical
Vertical
> Picture Tools | Format | Arrange | Rotate | Flip Vertical
Vertical
Draw | Reroute Connectors > Drawing Tools | Format | Insert Shapes | Edit Shape | Reroute Connectors
Draw | Edit Points > Drawing Tools | Format | Insert Shapes | Edit Shape | Edit Points
Draw | Change AutoShape Drawing Tools | Format | Insert Shapes | Edit Shape | Change Shape | Basic
>
| Basic Shapes Shapes
Draw | Change AutoShape Drawing Tools | Format | Insert Shapes | Edit Shape | Change Shape | Block
>
| Block Arrows Arrows
Draw | Change AutoShape Drawing Tools | Format | Insert Shapes | Edit Shape | Change Shape |
>
| Flowchart Flowchart
Draw | Change AutoShape Drawing Tools | Format | Insert Shapes | Edit Shape | Change Shape | Stars
>
| Stars and Banners and Banners
Draw | Change AutoShape

> Drawing Tools | Format | Insert Shapes | Edit Shape | Change Shape | Callouts
| Callouts
Draw | Set AutoShape Office Button | Excel Options | Customize | All Commands | Set AutoShape
>
Defaults Defaults
Select Objects > Ink Tools | Pens | Select | Select Objects
Select Objects > Home | Editing | Find & Select | Select Objects
AutoShapes | Lines > Insert | Illustrations | Shapes | Lines
AutoShapes | Connectors > Insert | Illustrations | Shapes | Connectors
AutoShapes | Basic
> Insert | Illustrations | Shapes | Basic Shapes
Shapes
AutoShapes | Block Arrows > Insert | Illustrations | Shapes | Block Arrows
AutoShapes | Flowchart > Insert | Illustrations | Shapes | Flowchart

AutoShapes | Stars and
> Insert | Illustrations | Shapes | Stars and Banners
Banners
AutoShapes | Callouts > Insert | Illustrations | Shapes | Callouts
AutoShapes | More
> Insert | Illustrations | Clip Art
AutoShapes
Line > Insert | Illustrations | Shapes
Arrow > Insert | Illustrations | Shapes
Rectangle > Insert | Illustrations | Shapes
Oval > Insert | Illustrations | Shapes
Text Box > Insert | Text | Text Box
Insert | Text | Vertical Text Box
*Vertical Text Box >
Drawing Tools | Format | Insert Shapes | Text Box | Vertical Text Box
WordArt > Insert | Text | WordArt
Diagram > Insert | Illustrations | SmartArt
Clip Art > Insert | Illustrations | Clip Art
Insert Picture from File > Insert | Illustrations | Picture
Insert Picture from File > Chart Tools | Layout | Insert | Picture
Insert Picture from File > PivotChart Tools | Layout | Insert | Picture
Ink Drawing and Writing > Review | Ink | Start Inking
Fill Color > Drawing Tools | Format | Shape Styles | Shape Fill
Line Color > Drawing Tools | Format | Shape Styles | Shape Outline
Font Color > Home | Font | Font Color
Line Style > Drawing Tools | Format | Shape Styles | Shape Outline | Weight
Dash Style > Drawing Tools | Format | Shape Styles | Shape Outline | Dashes
Arrow Style > Drawing Tools | Format | Shape Styles | Shape Outline | Arrows
Shadow Style > Drawing Tools | Format | Shape Styles | Shape Effects | Shadow
3-D Style > Drawing Tools | Format | Shape Styles | Shape Effects | 3-D Rotation
Office Button | Excel Options | Customize | All Commands | Select Multiple
Select Multiple Objects >
Objects
Excel: WordArt
Insert WordArt > Insert | Text | WordArt
Edit Text > Double click the WordArt Text to edit it.
These command are available on the Drawing Tools tabs when you select or
WordArt Gallery >
insert a WordArt Object.
Format Objects > Drawing Tools | Format | WordArt Styles | Dialog Launcher
WordArt Shape > Drawing Tools | Format | WordArt Styles | Text Effects | Transform
WordArt Same Letter
Heights
WordArt Vertical Text > Drawing Tools | Format | WordArt Styles | Dialog Launcher | Text Box
WordArt Alignment > Drawing Tools | Format | WordArt Styles | Dialog Launcher | Text Box
WordArt Character
Spacing
Excel: Pictures
Insert Picture from File > Insert | Illustrations | Picture
Insert Picture from File > Chart Tools | Layout | Insert | Picture
Insert Picture from File > PivotChart Tools | Layout | Insert | Picture
Color > Picture Tools | Format | Adjust | Recolor
More Contrast > Picture Tools | Format | Adjust | Contrast
Less Contrast > Picture Tools | Format | Adjust | Contrast
More Brightness > Picture Tools | Format | Adjust | Brightness
Less Brightness > Picture Tools | Format | Adjust | Brightness
Crop > Picture Tools | Format | Size | Crop
Rotate Left 90 > Page Layout | Arrange | Rotate | Rotate Left 90°
Rotate Left 90 > Drawing Tools | Format | Arrange | Rotate | Rotate Left 90°
Rotate Left 90 > Chart Tools | Format | Arrange | Rotate | Rotate Left 90°
Rotate Left 90 > PivotChart Tools | Format | Arrange | Rotate | Rotate Left 90°
Rotate Left 90 > SmartArt Tools | Format | Arrange | Rotate | Rotate Left 90°
Rotate Left 90 > Picture Tools | Format | Arrange | Rotate | Rotate Left 90°
Line Style > Picture Tools | Format | Picture Styles | Picture Border | Weight
Compress Pictures > Picture Tools | Format | Adjust | Compress Pictures
Format Object > Picture Tools | Format | Picture Styles | Dialog Launcher
Set Transparent Color > Picture Tools | Format | Adjust | Recolor | Set Transparent Color
Reset Picture > Picture Tools | Format | Adjust | Reset Picture
Excel: Drawing Canvas
Fit > Office Button | Excel Options | Customize | All Commands | Fit
Expand > Office Button | Excel Options | Customize | All Commands | Expand
Excel: Organization Chart
Insert Shape > SmartArt Tools | Design | Create Graphic | Layout | Add Shape
Layout | Standard > SmartArt Tools | Design | Create Graphic | Layout | Standard
Layout | Both Hanging > SmartArt Tools | Design | Create Graphic | Layout | Both
Layout | Left Hanging > SmartArt Tools | Design | Create Graphic | Layout | Left Hanging
Layout | Right Hanging > SmartArt Tools | Design | Create Graphic | Layout | Right Hanging
Layout | AutoLayout > SmartArt Tools | Design | Layouts
Click on each shape to select them. To select several shapes at the same time,
Select | Level >
keep Ctrl pressed while you click on the shapes.
Select | Branch >
Select | All Assistants >
Select | All Connecting Click on each shape to select them. To select several shapes at the same time,
>
Lines keep Ctrl pressed while you click on the shapes.
Autoformat > SmartArt Tools | Design | SmartArt Styles
Zoom > Status Bar | Zoom Slider
Excel: Diagram
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
> Click to resize and drag any corner of the diagram until you achive desired size.
Contents
Layout | Expand Diagram > SmartArt Tools | Format | Size
Select the diagram and click and drag any corner of the diagram's border until
Layout | Resize Diagram >
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
Excel: Ink Drawing and Writing
Drawing and Writing Pen > Ink Tools | Pens
Eraser > Ink Tools | Pens | Eraser
Select Objects > Home | Editing | Select | Select Objects
Line Color > Ink Tools | Format | Color
Line Style > Ink Tools | Format | Weight
Stop Erasing > Select a different writing tool to stop erasing.
Excel: Ink Annotations
Annotation Pen > Review | Ink | Start Inking
Eraser > Ink Tools | Pens | Pens | Eraser
Select Objects > Home | Editing | Find & Select | Select Objects
Line Color > Ink Tools | Format | Color
Line Style > Ink Tools | Format | Weight
Hide Ink Annotations > Review | Comments | Show Ink
Stop Erasing > Select a different writing tool to stop erasing.
Excel: Shadow Settings
Shadow On/Off > PivotChart Tools | Format | Shape Styles | Shape Effects | Shadow
Shadow On/Off > PivotChart Tools | Format | WordArt Styles | Text Effects | Shadow
Shadow On/Off > Chart Tools | Format | Shape Styles | Shape Effects | Shadow
Shadow On/Off > Chart Tools | Format | WordArt Styles | Text Effects | Shadow
Shadow On/Off > Drawing Tools | Format | Shape Styles | Shape Effects | Shadow
Shadow On/Off > Drawing Tools | Format | WordArt Styles | Text Effects | Shadow
Shadow On/Off > SmartArt Tools | Format | Shape Styles | Shape Effects | Shadow
Shadow On/Off > SmartArt Tools | Format | WordArt Styles | Text Effects | Shadow
Shadow On/Off > Picture Tools | Format | Picture Styles | Picture Effects | Shadow
Nudge Shadow PivotChart Tools | Format | Shape Styles | Dialog Launcher | Shadow |
>
Up/Down/Left/Right Angle/Distance
Nudge Shadow PivotChart Tools | Format | WordArt Styles | Dialog Launcher | Shadow |
>
Nudge Shadow Chart Tools | Format | Shape Styles | Dialog Launcher | Shadow |
>
Nudge Shadow Chart Tools | Format | WordArt Styles | Dialog Launcher | Shadow |
>
Nudge Shadow Drawing Tools | Format | Shape Styles | Dialog Launcher | Shadow |
>
Nudge Shadow Drawing Tools | Format | WordArt Styles | Dialog Launcher | Shadow |
>
Nudge Shadow SmartArt Tools | Format | Shape Styles | Dialog Launcher | Shadow |
>
Nudge Shadow SmartArt Tools | Format | WordArt Styles | Dialog Launcher | Shadow |
>
Nudge Shadow Picture Tools | Format | Picture Styles | Dialog Launcher | Shadow |
>
Shadow Color > PivotChart Tools | Format | Shape Styles | Dialog Launcher | Shadow | Color
Shadow Color > PivotChart Tools | Format | WordArt Styles | Dialog Launcher | Shadow | Color
Shadow Color > Chart Tools | Format | Shape Styles | Dialog Launcher | Shadow | Color
Shadow Color > Chart Tools | Format | WordArt Styles | Dialog Launcher | Shadow | Color
Shadow Color > Drawing Tools | Format | Shape Styles | Dialog Launcher | Shadow | Color
Shadow Color > Drawing Tools | Format | WordArt Styles | Dialog Launcher | Shadow | Color
Shadow Color > SmartArt Tools | Format | Shape Styles | Dialog Launcher | Shadow | Color
Shadow Color > SmartArt Tools | Format | WordArt Styles | Dialog Launcher | Shadow | Color
Shadow Color > Picture Tools | Format | Picture Styles | Dialog Launcher | Shadow | Color
Excel: 3-D Settings
3-D On/Off > Drawing Tools | Format | Shape Styles | Shape Effects | 3-D Rotation
3-D On/Off > Drawing Tools | Format | WordArt Styles | Text Effects | 3-D Rotation
3-D On/Off > SmartArt Tools | Format | Shape Styles | Shape Effects | 3-D Rotation
3-D On/Off > SmartArt Tools | Format | WordArt Styles | Text Effects | 3-D Rotation
3-D On/Off > Picture Tools | Format | Picture Styles | Picture Effects | 3-D Rotation
Drawing Tools | Format | Shape Styles | Dialog Launcher | 3-D Rotation |
Tilt Down/Up/Left/Right >
Rotation
Drawing Tools | Format | WordArt Styles | Dialog Launcher | 3-D Rotation |
Rotation
SmartArt Tools | Format | Shape Styles | Dialog Launcher | 3-D Rotation |
Rotation
SmartArt Tools | Format | WordArt Styles | Dialog Launcher | 3-D Rotation |
Rotation
Picture Tools | Format | Picture Styles | Dialog Launcher | 3-D Rotation |
Rotation
Drawing Tools | Format | Shape Styles | Dialog Launcher | 3-D Format | Depth |
Depth >
Depth
Drawing Tools | Format | WordArt Styles | Dialog Launcher | 3-D Format | Depth
Depth >
| Depth
SmartArt Tools | Format | Shape Styles | Dialog Launcher | 3-D Format | Depth |
Depth >
Depth
SmartArt Tools | Format | WordArt Styles | Dialog Launcher | 3-D Format |
Depth >
Depth | Depth
Picture Tools | Format | Picture Styles | Dialog Launcher | 3-D Format | Depth |
Depth >
Depth
Direction > Drawing Tools | Format | Shape Styles | Shape Effects | 3-D Rotation
Direction > Drawing Tools | Format | WordArt Styles | Text Effects | 3-D Rotation
Direction > SmartArt Tools | Format | Shape Styles | Shape Effects | 3-D Rotation
Direction > SmartArt Tools | Format | WordArt Styles | Text Effects | 3-D Rotation
Direction > Picture Tools | Format | Picture Styles | Picture Effects | 3-D Rotation
Drawing Tools | Format | Shape Styles | Dialog Launcher | 3-D Format | Surface
Lighting >
| Lighting
Drawing Tools | Format | WordArt Styles | Dialog Launcher | 3-D Format |
Lighting >
Surface | Lighting
SmartArt Tools | Format | Shape Styles | Dialog Launcher | 3-D Format |
Lighting >
Surface | Lighting
Lighting >
Surface | Lighting
Picture Tools | Format | Picture Styles | Dialog Launcher | 3-D Format | Surface
Lighting >
| Lighting
Drawing Tools | Format | Shape Styles | Dialog Launcher | 3-D Format | Surface
Surface >
| Material
Drawing Tools | Format | WordArt Styles | Dialog Launcher | 3-D Format |
Surface >
Surface | Material
SmartArt Tools | Format | Shape Styles | Dialog Launcher | 3-D Format |
Surface >
Surface | Material
Surface >
Surface | Material
Picture Tools | Format | Picture Styles | Dialog Launcher | 3-D Format | Surface
Surface >
| Material
Drawing Tools | Format | Shape Styles | Dialog Launcher | 3-D Format | Depth |
3-D Color >
Color
Drawing Tools | Format | WordArt Styles | Dialog Launcher | 3-D Format | Depth
3-D Color >
| Color
SmartArt Tools | Format | Shape Styles | Dialog Launcher | 3-D Format | Depth |
3-D Color >
Color
3-D Color >
Depth | Color
Picture Tools | Format | Picture Styles | Dialog Launcher | 3-D Format | Depth |
3-D Color >
Color
Excel: File
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 as Web Page > Office Button | Save As | Save as type | Web Page
Save Workspace > View | Window | Save Workspace
File Search > Windows Start button | Search
Permission | Unrestricted Access > Office Button | Prepare | Restrict Permission | Unrestricted Access
Permission | Unrestricted Access > Review | Changes | Protect Workbook | Unrestricted Access
Permission | Do Not Distribute > Office Button | Prepare | Restrict Permission | Restricted Access
Permission | Do Not Distribute > Review | Changes | Protect Workbook | Restricted Access
Permission | Restrict Permission As > Office Button | Prepare | Restrict Permission | Manage Credentials
Permission | Restrict Permission As > Review | Changes | Protect Workbook | Manage Credentials
Check Out > Office Button | Check Out
Check In > Office Button | Check In
Version History > Office Button | View Version History
Office Button | Excel Options | Customize | All Commands | Web
Web Page Preview >
Page Preview
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
Print > Print Preview | Print | Print
Office Button | Excel Options | Customize | All Commands | Mail
Send To | Mail Recipient >
Recipient
Office Button | Excel Options | Customize | All Commands | Reply
Send To | Original Sender >
with Changes
Office Button | Excel Options | Customize | All Commands | Send
Send To | Mail Recipient (for Review) >
for Review
Send To | Mail Recipient (as
> Office Button | Send | E-mail
Attachment)
Send To | Routing Recipient > Removed from product
Send To | Exchange Folder >
Exchange Folder
Send To | Online Meeting Participant > Removed from product
Send To | Recipient using Internet Fax
> Office Button | Send | Internet Fax
Service
Properties > Office Button | Prepare | Properties
Most Recently Used Documents > Office Button | Most Recently Used Documents
Exit > Office Button | Exit
Excel: Edit
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.
Clear | Series > Removed from product
Excel: View
Normal > View | Workbook Views | Normal
Page Break Preview > View | Workbook Views | Page Break Preview
In some groups, dialog box launchers will display a Task Pane instead of a
Task Pane >
dialog box. For example, Home | Clipboard | Dialog Launcher
These commands are available on the Home Tab and/or the Office Button
Toolbars | Standard >
Menu.
Toolbars | Formatting > These commands are available on the Home Tab.
Toolbars | Borders > Home | Font | Borders
These commands are available in the Chart Tools when a Chart is inserted or
Toolbars | Chart >
selected.
These commands are available on the Developer Tab. To display the Developer
Toolbars | Control Toolbox > Tab, click Office Button | Excel Options | Popular, and then select the Show
Developer tab in the Ribbon check box.
These commands are available on the Drawing Tools when a shape is inserted
Toolbars | Drawing >
or selected.
Toolbars | External Data > These commands are available on the Data Tab.
Toolbars | Forms > Tab, click Office Button | Excel Options | Popular, and then select the Show
Toolbars | Formula
> Formula | Formula Auditing
Auditing
The majority of these commands are available on the Table Tools tabs when
Toolbars | List >
you select a cell in an Excel table.
These commands are available on the Picture Tools tabs when a picture is
Toolbars | Picture >
inserted or selected.
These commands are available on the PivotTable Tools tabs when a cell in a
Toolbars | PivotTable >
PivotTable is inserted or selected.
Toolbars | Protection > Review Tab | Changes
Toolbars | Reviewing > These commands are avialable on the Review Tab.
In some groups, dialog box launchers will display a Task Pane instead of a
Toolbars | Task Pane >
dialog box. For example, Home | Clipboard | Dialog Launcher
Toolbars | Text To Speech > Removed from product
Toolbars | Visual Basic > Tab, click Office Button | Excel Options | Popular, and then select the Show
Toolbars | Watch Window > Formulas | Formula Auditing | Watch Window
These commands are available in the Excel Options dialog box. Click Office
Toolbars | Web >
Button | Excel Options | Customize | All Commands dialog
These commands are available on the Drawing Tools tabs when WordArt is
Toolbars | WordArt >
inserted or selected.
These commands are available in the Excel Options dialog box. Click Office
Toolbars | Customize >
Button | Excel Options | Customize dialog
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
Custom Views > View | Workbook Views | Custom Views
Full Screen > View | Workbook Views | Full Screen
Zoom > View | Zoom | Zoom
Sized with Window > Removed from product
Chart Window > Removed from product
Excel: Insert
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
Function > Formulas | Function Library | Insert Function
Function > Formulas | Function Library | Date & Time | Insert Function
Function > Formulas | Function Library | Math & Trig | Insert Function
Function > Formulas | Function Library | Financial | Insert Function
Function > Formulas | Function Library | Logical | Insert Function
Function > Formulas | Function Library | Lookup & Reference | Insert Function
Function > Formulas | Function Library | Recently Used | Insert Function
Function > Formulas | Function Library | Text | Insert Function
Function > Formulas | Function Library | More Functions | Cube | Insert Function
Function > Formulas | Function Library | More Functions | Engineering | Insert Function
Function > Formulas | Function Library | More Functions | Information | Insert Function
Function > Formulas | Function Library | More Functions | Statistical | Insert Function
Name | Define > Formulas | Defined Names | Name Manager
Name | Paste > Formulas | Defined Names | Use in Formula | Paste Names
Name | Create > Formulas | Defined Names | Create from Selection
Name | Apply > Formulas | Defined Names | Define Name | Apply Names
Name | Label > Formulas | Defined Names | Define Name
Comment > Review | Comments | New Comment
Ink Annotations > Review | Ink | Start Inking
Picture | Clip Art > Insert | Illustrations | Clip Art
Picture | From File > Insert | Illustrations | Picture
Picture | From File > Chart Tools | Layout | Insert | Picture
Picture | From File > PivotChart Tools | Layout | Insert | Picture
Picture | From Scanner or
> Remved from product
Camera
Picture | Ink Drawing and
> Review | Ink | Start Inking
Writing
Picture | AutoShapes > Insert | Illustrations | Shapes
Picture | WordArt > Insert | Illustrations | WordArt
Picture | Organization Chart > insert Illustrations | SmartArt
Diagram > Insert | Illustrations | SmartArt
Object > Insert | Text | Object
Hyperlink > Insert | Links | Hyperlink
Excel: Format
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
Excel: Tools
Spelling > Review | Proofing | Spelling
Research > Review | Proofing | Research
Error Checking > Formulas | Formula Auditing | Error Checking
Speech | Show Text To
Speech Toolbar
Speech > Removed from product
Shared Workspace > Office Button | Publish | Create Document Workspace
Share Workbook > Review | Changes | Share Workbook
Track Changes | Highlight
> Review | Changes | Track Changes | Highlight Changes
Changes
Track Changes | Accept or
> Review | Changes | Track Changes | Accept/Reject Changes
Reject Changes
Compare and Merge Office Button | Excel Options | Customize | All Commands |
>
Workbooks Compare and Merge Workbooks
Protection | Protect Sheet > Review | Changes | Protect Sheet
Protection | Protect Sheet > Home | Cells | Format | Protect Sheet
Protection | Allow Users to
> Review | Changes | Allow Users to Edit Ranges
Edit Ranges
Protection | Protect
> Review | Changes | Protect Workbook
Workbook
Protection | Protect and
> Review | Changes | Protect and Share Workbook
Share Workbook
Online Collaboration | Meet
Now
Online Collaboration |
Schedule Meeting
Online Collaboration | Web
Discussions
Online Collaboration | End
Review
Goal Seek > Data | Data Tools | What-If Analysis | Goal Seek
Scenarios > Data | Data Tools | What-If Analysis | Scenario Manager
Formula Auditing | Trace
> Formulas | Formula Auditing | Trace Precedents
Precedents
> Formulas | Formula Auditing | Trace Dependents
Dependents
> Formulas | Formula Auditing | Error Checking | Trace Error
Error
Formula Auditing | Remove
> Formulas | Formula Auditing | Remove Arrows
All Arrows
Formula Auditing | Remove
> Formulas | Formula Auditing | Remove Arrows | Remove Arrows
All Arrows
Formula Auditing |
> Formulas | Formula Auditing | Evaluate Formula
Evaluate Formula
Formula Auditing | Hide
> Formulas | Formula Auditing | Watch Window
Watch Window
Formula Auditing | Formula
> Formulas | Formula Auditing | Show Formulas
Auditing Mode
Formula Auditing | Show
> Formulas | Formula Auditing
Formula Auditing Toolbar
Macro | Macros > Developer | Code | Macros
Macro | Macros > View | Macros | Macros
Macro | Record New
> Developer | Code | Record Macro
Macro
Macro | Record New
> View | Macros | Macros | Record Macro
Macro
Macro | Security > Developer | Code | Macro Security
Macro | Visual Basic Editor > Developer | Code | Visual Basic
Macro | Microsoft Script

Editor
Add-Ins > Office Button | Excel Options | Add-Ins
AutoCorrect Options > Office Button | Excel Options | Proofing | AutoCorrect Options
Customize > Office Button | Excel Options | Customize
Show Signatures > Office Button | Prepare | Add a Digital Signature
Options > Office Button | Excel Options
Excel: Data
Sort >
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 >
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
> Data | Outline | Hide Detail
Detail
Group and Outline | Show
> Data | Outline | Show Detail
Detail
Group and Outline | Group > Data | Outline | Group
Group and Outline | Group > PivotTable Tools | Options | Group
Group and Outline |
> Data | Outline | Ungroup
Ungroup
Group and Outline |
> PivotTable Tools | Options | Ungroup
Ungroup
Group and Outline | Auto
> Data | Outline | Group | Auto Outline
Outline
Group and Outline | Clear
> Data | Outline | Ungroup | Clear Outline
Outline
Group and Outline |
> Data | Outline | Group and Outline Settings
Settings
PivotTable and PivotChart
> Insert | Tables | PivotTable | PivotTable/PivotChart
Report
Import External Data |
> Data | Get External Data
Import Data
Import External Data | New
> Data | Get External Data | From Web
Web Query
Import External Data | New Data | Get External Data | From Other Sources | From
>
Database Query Microsoft Query
Import External Data | Edit Office Button | Excel Options | Customize | All Commands |
>
Query Edit Query
Import External Data | Data
> Data | Connections | Properties
Range Properties
Import External Data | Data
> Table Tools | Design | External Table Data | Properties
Range Properties
Import External Data | Office Button | Excel Options | Customize | All Commands |
>
Parameters 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
Table Tools | Design | External Table Data | Export | Export
List | Publish List >
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 >
Synchronize List
List | Discard Changes and Office Button | Excel Options | Customize | All Commands |
>
Refresh Discard Changes and Refresh
List | Hide Border of
Inactive Lists
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
> Developer | XML | Expansion Packs
Packs
Refresh Data > PivotChart Tools | Analyze | 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
Excel: Chart (Menu)
Chart Type > Chart Tools | Design | Type | Change Chart Type
Source Data > Chart Tools | Design | Data | Select Data
Source Data > PivotChart Tools | Design | Data | Select Data
Chart Options > Chart | Layout
Location > Chart Tools | Design | Location | Move Chart
Location > PivotChart Tools | Design | Location | Move Chart
Add Data > Chart Tools | Design | Data | Edit Data Source
Add Trendline > Chart Tools | Layout | Analysis | Trendline
3-D View > Chart Tools | Layout | Background | 3-D View
Excel: Window
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

Excel: Help
Microsoft Excel Help > Upper Ribbon | Help
Microsoft Office Online > Office Button | Excel Options | Resources | Microsoft Office Online
Contact Us > Office Button | Excel Options | Resources | Contact Us
Check for Updates > Office Button | Excel Options | Resources | Check for Updates
Detect and Repair > Office Button | Excel Options | Resources | Diagnose
Activate Product > Office Button | Excel Options | Resources | Activate
Customer Feedback Office Button | PowerPoint Options | Trust Center | Protecting Your Privacy |
>
Options Customer Experience Improvement Program
About Microsoft Office
> Office Button | Excel Options | Resources | About
Excel

Locations of Excel 2003 Commands in Excel 2007

Uploaded by

Copyright:

Available Formats

Locations of Excel 2003 Commands in Excel 2007

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Locations of Excel 2003 Commands in Excel 2007

Uploaded by

Copyright:

Available Formats

Reference: Locations of Excel 2003 commands in Excel 2007

Tips for using this workbook

3. To search for a specific command in this workbook, do one of the following:

4. To print, do one of the following:

• In Excel 2007, click the Microsoft Office Button

Open > Office Button | Open

Save > Quick Access Toolbar | Save

Save > Office Button | Save

Permission > Office Button | Prepare | Restrict Permission | Restrict Permission As

Email > Office Button | Send | Email

Print > Office Button | Print | Quick Print

Print Preview > Office Button | Print | Print Preview

Spelling > Review | Proofing | Spelling

Research > Review | Proofing | Research

Cut > Home | Clipboard | Cut

Copy > Home | Clipboard | Copy

Paste > Home | Clipboard | Paste

Format Painter > Home | Clipboard | Format Painter

Undo > Quick Access Toolbar | Undo

Redo > Quick Access Toolbar | Redo

Ink Annotations > Review | Ink | Start Inking

Hyperlink > Insert | Links | Hyperlink

AutoSum > Home | Editing | AutoSum

AutoSum > Formulas | Function Library | AutoSum

Sort Ascending > Data | Sort & Filter | Sort A to Z

Sort Descending > Data | Sort & Filter | Sort Z to A

Chart Wizard > Insert | Charts

Font Size > Home | Font | Font Size

Bold > Home | Font | Bold

Italic > Home | Font | Italic

Underline > Home | Font | Underline | Underline

Align Left > Home | Alignment | Align Left

Center > Home | Alignment | Center

Align Right > Home | Alignment | Align Right

Merge and Center > Home | Alignment | Merge & Center

Currency Style > Home | Number | Accounting Number Format

Percent Style > Home | Number | Percent Style

Comma Style > Home | Number | Comma Style

Increase Decimal > Home | Number | Increase Decimal

Decrease Decimal > Home | Number | Decrease Decimal

Decrease Indent > Home | Alignment | Decrease Indent

Increase Indent > Home | Alignment | Increase Indent

Borders > Home | Font | Borders

Fill Color > Home | Font | Fill Color

Font Color > Home | Font | Font Color

Chart | Chart Options > Chart | Layout

Chart | Location > Chart Tools | Design | Location | Move Chart

Chart | Location > PivotChart Tools | Design | Location | Move Chart

Chart | Add Trendline > Chart Tools | Layout | Analysis | Trendline

AutoFormat > Home | Styles | Format as Table

Cells > Home | Cells | Format | Format Cells

Increase Font Size > Home | Font | Increase Font Size

Decrease Font Size > Home | Font | Decrease Font Size

Text Direction > Home | Alignment | Orientation

Sort and Top 10 > PivotTable Tools | Options |Sort

Trace Dependents > Formulas | Formula Auditing | Trace Dependents

Draw Border | Draw Border

Draw | Change AutoShape

AutoShapes | Block Arrows > Insert | Illustrations | Shapes | Block Arrows

AutoShapes | Flowchart > Insert | Illustrations | Shapes | Flowchart