Excel 2007 Cheat Sheet: Quick reference charts

Find your favorite Excel 2003 commands in the new Excel 2007 interface

clear.gif

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

clear.gif

Tools Menu

Excel 2003 Location

Excel 2007 Location

Keyboard Shortcut

Tools > SpellingReview > Proofing > SpellingF7
Tools > ResearchReview > Proofing > ResearchAlt-Click
Tools > Error CheckingFormulas > Formula Auditing > Error CheckingAlt-T, K
Tools > SpeechNot in Excel 2007

In Excel 2003: Alt-T, H

In Excel 2007: not available
Tools > Shared WorkspaceOffice button > Publish > Create Document WorkspaceAlt-T, D
Tools > Share WorkbookReview > Changes > Share Workbook

In Excel 2003: Alt-T, B

In Excel 2007: Alt-T, B or Alt-R, W
Tools > Track ChangesReview > Changes > Track Changes

In Excel 2003: Alt-T, T

In Excel 2007: Alt-R, G
Tools > Compare and Merge WorkbooksAdd to Quick Access tool bar: Office button > Excel Options > Customize > All Commands > Compare and Merge WorkbooksAlt-T, W
Tools > ProtectionReview > Changes

In Excel 2003: Alt-T, P

In Excel 2007: Alt-R, [letter depends on type of protection]
Tools > Online CollaborationNot in Excel 2007

In Excel 2003: Alt-T, N

In Excel 2007: not available
Tools > Goal SeekData > Data Tools > What-If Analysis > Goal SeekAlt-T, G
Tools > ScenariosData > Data Tools > What-If Analysis > Scenario ManagerAlt-T, E
Tools > Formula AuditingFormulas > Formula Auditing

In Excel 2003: Alt-T, U

In Excel 2007: Alt-M, [letter depends on type of formula auditing]
Tools > Macro

View > Macros > Macros

or

Developer > Code > Macros

In Excel 2003: Alt-T, M

In Excel 2007: Alt-W, M
Tools > Add-InsOffice button > Excel Options > Add-InsAlt-T, I
Tools > AutoCorrect OptionsOffice button > Excel Options > Proofing > AutoCorrect OptionsAlt-T, A
Tools > CustomizeOffice button > Excel Options > Customize

In Excel 2003: Alt-T, C

In Excel 2007: Alt-F, I, C
Tools > OptionsOffice button > Excel Options

In Excel 2003: Alt-T, O

In Excel 2007: Alt-T, O or Alt-F, I

Return to Excel 2007 Cheat Sheet

1 2 3 4 5 6 7 8 Page 6
Page 6 of 8
It’s time to break the ChatGPT habit
Shop Tech Products at Amazon