Excel 2010 cheat sheet: Quick reference charts

FREE

Become An Insider

Sign up now and get free access to hundreds of Insider articles, guides, reviews, interviews, blogs, and other premium content from the best tech brands on the Internet: CIO, CITEworld, CSO, Computerworld, InfoWorld, ITworld and Network World. Learn more.

New to Microsoft Excel 2010? Find your favorite commands from earlier versions of Excel with these charts.

These charts accompany our story Excel 2010 cheat sheet. Click through to that story for detailed information on getting up and running with Excel 2010.

If you've upgraded to Excel 2010 directly from Excel 2003, you'll probably have difficulty finding some of your favorite menu commands in the new Ribbon interface. Even Excel 2007 users might have trouble finding one or two things in Excel 2010. These quick reference charts can help.

We list the most commonly used Excel 2003 commands and tell you where they are in both Excel 2007 and Excel 2010. They're listed here according to the menu on which they're found in Excel 2003. We've also included keyboard shortcuts for all the commands. Most of them are the same in all three versions of Excel; we've noted where they differ.

File Menu  |  Edit Menu  |  View Menu  |  Insert Menu  |  Format Menu  |  Tools Menu  |  Data Menu  |  Window Menu

View menu

File Menu  |  Edit Menu  |  View Menu  |  Insert Menu  |  Format Menu  |  Tools Menu  |  Data Menu  |  Window Menu

Tools menu

Excel 2003 location Excel 2007 location Excel 2010 location Keyboard shortcut
Tools menu > Spelling Review tab > Proofing group > Spelling Review tab > Proofing group > Spelling F7
Tools menu > Research Review tab > Proofing group > Research Review tab > Proofing group > Research Alt-Click
Tools menu > Error Checking Formulas tab > Formula Auditing group > Error Checking Formulas tab > Formula Auditing group > Error Checking Alt-T, K
Tools menu > Share Workbook Review tab > Changes group > Share Workbook Review tab > Changes group > Share Workbook Excel 2003: Alt-T, B
Excel 2007/2010: Alt-T, B or Alt-R, W
Tools menu > Track Changes Review tab > Changes group > Track Changes Review tab > Changes group > Track Changes Excel 2003: Alt-T, T
Excel 2007/2010: Alt-R, G
Tools menu > Compare and Merge Workbooks Add to Quick Access toolbar: Office button > Excel Options > Customize > All Commands > Compare and Merge Workbooks Add to Quick Access toolbar: File tab > Options > Quick Access Toolbar > All Commands > Compare and Merge Workbooks Alt-T, W
Tools menu > Protection Review tab > Changes group > choose protection type Review tab > Changes group > choose protection type Excel 2003: Alt-T, P
Excel 2007/2010: Alt-R, [letter depends
on type of protection]
Tools menu > Goal Seek Data tab > Data Tools group > What-If Analysis > Goal Seek Data tab > Data Tools group > What-If Analysis > Goal Seek Alt-T, G
Tools menu > Scenarios Data tab > Data Tools group > What-If Analysis > Scenario Manager Data tab > Data Tools group > What-If Analysis > Scenario Manager Alt-T, E
Tools menu > Formula Auditing Formulas tab > Formula Auditing group > choose auditing type Formulas tab > Formula Auditing group > choose auditing type Excel 2003: Alt-T, U
Excel 2007/2010: Alt-M, [letter depends
on type of formula auditing]
Tools menu > Macro View tab > Macros group > Macros or Developer tab > Code group > Macros View tab > Macros group > Macros or Developer tab > Code group > Macros Excel 2003: Alt-T, M
Excel 2007/2010: Alt-W, M
Tools menu > Add-Ins Office button > Excel Options > Add-Ins File tab > Options > Add-Ins Alt-T, I
Tools menu > AutoCorrect Options Office button > Excel Options > Proofing > AutoCorrect Options File tab > Options > Proofing > AutoCorrect Options Alt-T, A
Tools menu > Options Office button > Excel Options File tab > Options Alt-T, O

Data menu

Excel 2003 location Excel 2007 location Excel 2010 location Keyboard shortcut
Data menu > Sort Data tab > Sort & Filter group > Sort
or
Home tab > Editing group > Sort & Filter > Sort
Data tab > Sort & Filter group > Sort
or
Home tab > Editing group > Sort & Filter > choose sort/filter option
Excel 2003: Alt-D, S
Excel 2007/2010: Alt-A, S
Data menu > Filter Data tab > Sort & Filter group > Filter
or
Home tab > Editing group > Sort & Filter > Filter
Data tab > Sort & Filter group > Filter
or
Home tab > Editing group > Sort & Filter > choose sort/filter option
Excel 2003: Alt-D, F
Excel 2007/2010: Alt-A, T
Data menu > Subtotals Data tab > Outline group > Subtotal Data tab > Outline group > Subtotal Excel 2003: Alt-D, B
Excel 2007/2010: Alt-D, B or Alt-A, B
Data menu > Validation Data tab > Data Tools group > Data Validation Data tab > Data Tools group > Data Validation Excel 2003: Alt-D, L
Excel 2007/2010: Alt-D, L or Alt-A, V
Data menu > Table Data tab > Data Tools group > What-If Analysis > Data Table Data tab > Data Tools group > What-If Analysis > Data Table Alt-D, T
Data menu > PivotTable and PivotChart Report Insert tab > Tables group > PivotTable > PivotTable/PivotChart Insert tab > Tables group > PivotTable > PivotTable/PivotChart Alt-D, P
Data menu > Import External Data Data tab > Get External Data group > choose data source Data tab > Get External Data group > choose data source Excel 2003: Alt-D, D
Excel 2007/2010: Alt-A, [letter depends on data source]
Data menu > Refresh Data Data table > Connections group > Refresh All > Refresh All Data table > Connections group > Refresh All > Refresh All Excel 2003: Alt-D, R
Excel 2007/2010: Alt-A, R, A

Window menu

Excel 2003 location Excel 2007 location Excel 2010 location Keyboard shortcut
Window menu > New Window View tab > Window group > New Window View tab > Window group > New Window Alt-W, N
Window menu > Arrange View tab > Window group > Arrange All View tab > Window group > Arrange All Alt-W, A
Window menu > Compare Side by Side with View tab > Window group > View Side by Side View tab > Window group > View Side by Side Alt-W, B
Window menu > Hide View tab > Window group > Hide View tab > Window group > Hide Alt-W, H
Window menu > Unhide View tab > Window group > Unhide View tab > Window group > Unhide Alt-W, U
Window menu > Split /
Remove Split
View tab > Window group > Split View tab > Window group > Split Alt-W, S (toggle)
Window menu > Freeze Panes / Unfreeze Panes View tab > Window group > Freeze Panes > Freeze Panes / Unfreeze Panes View tab > Window group > Freeze Panes > Freeze Panes / Unfreeze Panes Excel 2003: Alt-W, F (toggle)
Excel 2007/2010: Alt-W, F, F (toggle)
Window menu > Currently Open Workbooks View tab > Window group > Switch Windows View tab > Window group > Switch Windows Excel 2003: Alt-W
Excel 2007/2010: Alt-W, W
Source: Microsoft

To continue reading, please begin the free registration process or sign in to your Insider account by entering your email address:
FREE Computerworld Insider Guide: IT Certification Study Tips
Join the discussion
Be the first to comment on this article. Our Commenting Policies