Excel 2007: converting from the Excel 2003 menus to the Excel 2007 Ribbon
By SimeyC
Excel 2007: The Ribbon
When Microsoft updated Excel from the 2003 version to 2007 version they added functionality to many functions; for example they gave you the ability to sort by color. However, the underlying functionality really didn't change that much, it just got slightly better.
However, the most significant change within Excel was the introduction of The Ribbon. With companies like Apple and Google gaining ground on Microsoft with their own spreadsheet programs, Microsoft introduced The Ribbon to make the spreadsheet more intuitive and therefore more effective.
While The Ribbon is a great improvement over the old menu drive spreadsheet, many users who have grown up using Microsoft Excel were initially put off.
For me, while it is far more intuitive, it took me a while to find all the functionality that I was used to - I therefore created a 'cheat sheet' that easily allowed me to look up a menu item that I used to use in Excel 2003 and find the corresponding item in The Ribbon.
Hopefully the tables below will be as useful to you as they were to me:
 | Amazon Price: $19.80 List Price: $34.99 |
Excel 2003 File Menu
Excel 2003 Location
| Excel 2007 Location
|
|---|---|
File > New
| Office button > New
|
File > Open
| Office button > Open
|
File > Close
| Office button > Close
|
File > Save
| Office button > Save or Quick Access tool bar > Save icon
|
File > Save As
| Office button > Save As
|
File > Save As Web Page
| Office button > Save As (in Save As dialog, choose Web Page from Save As Type drop-down)
|
File > Save Workspace
| View > Window > Save Workspace
|
File > File Search
| Windows Start button > Search
|
File > Permission
| Office button > Prepare > Restrict Permission
|
File > Web Page Preview
| Add to Quick Access tool bar: Office button > Excel Options > Customize > All Commands > Web Page Preview
|
File > Page Setup
| Page Layout > Page Setup (click dialog box launcher for more options) or Office button > Print > Print Preview > Page Setup icon
|
File > Print Area
| Page Layout > Page Setup > Print Area
|
File > Print Preview
| Office button > Print > Print Preview
|
File > Print
| Office button > Print
|
File > Send To
| Office button > Send (for more Send options, see Office button > Excel Options > Customize > All Commands)
|
File > Most Recently Used Documents
| Office button > Recent Documents
|
Excel 2003 Edit Menu
Excel 2003 Location
| Excel 2007 Location
|
|---|---|
Edit > Undo
| Quick Access tool bar > Undo icon
|
Edit > Redo
| Quick Access tool bar > Redo icon
|
Edit > Cut
| Home > Clipboard > Cut
|
Edit > Copy
| Home > Clipboard > Copy
|
Edit > Office Clipboard
| Home > Clipboard dialog box launcher
|
Edit > Paste
| Home > Clipboard > Paste
|
Edit > Paste Special
| Home > Clipboard > Paste > Paste Special
|
Edit > Paste as Hyperlink
| Home > Clipboard > Paste > Paste as Hyperlink
|
Edit > Fill
| Home > Editing > Fill
|
Edit > Clear
| Home > Editing > Clear
|
Edit > Delete
| Home > Cells > Delete
|
Edit > Delete Sheet
| Home > Cells > Delete > Delete Sheet
|
Edit > Move or Copy Sheet
| Home > Cells > Format > Move or Copy Sheet
|
Edit > Find
| Home > Editing > Find & Select > Find
|
Edit > Replace
| Home > Editing > Find & Select > Replace
|
Edit > Go To
| Home > Editing > Find > Find & Select > Go To
|
Excel 2003 View Menu
Excel 2003 Location
| Excel 2007 Location
|
|---|---|
View > Normal
| View > Workbook Views > Normal
|
View > Page Break Preview
| View > Workbook Views > Page Break Preview
|
View > Task Pane
| The overall task pane is gone in Excel 2007, but some dialog box launchers display task panes.
|
View > Tool bars
| Excel 2007 no longer has tool bars.
|
View > Formula Bar
| View > Show/Hide > Formula Bar
|
View > Status Bar
| The Status Bar is always visible.
|
View > Header and Footer
| Insert > Text > Header & Footer
|
View > Comments
| Review > Comments > Show All Comments
|
View > Custom Views
| View > Workbook Views > Custom Views
|
View > Full Screen
| View > Workbook Views > Full Screen
|
View > Zoom
| View > Zoom > Zoom
|
Excel 2003 Insert Menu
Excel 2003 Location
| Excel 2007 Location
|
|---|---|
Insert > Cells
| Home > Cells > Insert > Insert Cells
|
Insert > Rows
| Home > Cells > Insert > Insert Sheet Rows
|
Insert > Columns
| Home > Cells > Insert > Insert Sheet Columns
|
Insert > Worksheet
| Home > Cells > Insert > Insert Sheet
|
Insert > Chart
| Insert > Charts
|
Insert > Symbol
| Insert > Text > Symbol
|
Insert > Page Break
| Page Layout > Page Setup > Breaks > Insert Page Break
|
Insert > Function
| Formulas > Function Library > Insert Function
|
Insert > Name
| Formulas > Defined Names
|
Insert > Comment
| Review > Comments > New Comment
|
Insert > Picture
| Insert > Illustrations
|
Insert > Diagram
| Insert > Illustrations > SmartArt
|
Insert > Object
| Insert > Text > Object
|
Insert > Hyperlink
| Insert > Links > Hyperlink
|
Excel 2003 Format Menu
Excel 2003 Location
| Excel 2007 Location
|
|---|---|
Format > Cells
| Home > Cells > Format > Format Cells
|
Format > Row
| Home > Cells > Format
|
Format > Column
| Home > Cells > Format
|
Format > Sheet
| Home > Cells > Format
|
Format > AutoFormat
| Home > Styles > Format as Table
|
Format > Conditional Formatting
| Home > Styles > Conditional Formatting
|
Format > Style
| Home > Styles > Cell Styles
|
Excel 2003 Tools Menu
Excel 2003 Location
| Excel 2007 Location
|
|---|---|
Tools > Spelling
| Review > Proofing > Spelling
|
Tools > Research
| Review > Proofing > Research
|
Tools > Error Checking
| Formulas > Formula Auditing > Error Checking
|
Tools > Speech
| Not in Excel 2007
|
Tools > Shared Workspace
| Office button > Publish > Create Document Workspace
|
Tools > Share Workbook
| Review > Changes > Share Workbook
|
Tools > Track Changes
| Review > Changes > Track Changes
|
Tools > Compare and Merge Workbooks
| Add to Quick Access tool bar: Office button > Excel Options > Customize > All Commands > Compare and Merge Workbooks
|
Tools > Protection
| Review > Changes
|
Tools > Online Collaboration
| Not in Excel 2007
|
Tools > Goal Seek
| Data > Data Tools > What-If Analysis > Goal Seek
|
Tools > Scenarios
| Data > Data Tools > What-If Analysis > Scenario Manager
|
Tools > Formula Auditing
| Formulas > Formula Auditing
|
Tools > Macro
| View > Macros > Macros or Developer > Code > Macros
|
Tools > Add-Ins
| Office button > Excel Options > Add-Ins
|
Tools > AutoCorrect Options
| Office button > Excel Options > Proofing > AutoCorrect Options
|
Tools > Customize
| Office button > Excel Options > Customize
|
Tools > Options
| Office button > Excel Options
|
Excel 2003 Data Menu
Excel 2003 Location
| Excel 2007 Location
|
|---|---|
Data > Sort
| Data > Sort & Filter > Sort or Home > Editing > Sort & Filter > Sort
|
Data > Filter
| Data > Sort & Filter > Filter or Home > Editing > Sort & Filter > Filter
|
Data > Form
| Add to Quick Access tool bar: Office button > Excel Options > Customize > All Commands > Form
|
Data > Subtotals
| Data > Outline > Subtotal
|
Data > Validation
| Data > Data Tools > Data Validation
|
Data > Table
| Data > Data Tools > What-If Analysis > Data Table
|
Data > Text to Columns
| Data > Data Tools > Convert Text to Table
|
Data > Consolidate
| Data > Data Tools > Consolidate
|
Data > Group and Outline
| Data > Outline
|
Data > PivotTable and PivotChart Report
| Insert > Tables > PivotTable > PivotTable/PivotChart
|
Data > Import External Data
| Data > Get External Data
|
Data > List
| Data > Get External Data
|
Data > XML
| Developer > XML
|
Data > Refresh Data
| Data > Connections > Refresh All > Refresh All
|
Excel 2003 Window Menu
Excel 2003 Location
| Excel 2007 Location
|
|---|---|
Window > New Window
| View > Window > New Window
|
Window > Arrange
| View > Window > Arrange All
|
Window > Compare Side by Side with
| View > Window > View Side by Side
|
Window > Hide
| View > Window > Hide
|
Window > Unhide
| View > Window > Unhide
|
Window > Split/Remove Split
| View > Window > Split/Remove Split
|
Window > Freeze Panes/Unfreeze Panes
| View > Window > Freeze Panes > Freeze Panes/Unfreeze Panes
|
Window > Currently Open Workbooks
| View > Window > Switch Windows
|
Comments
No comments yet.
