Datasheet

Excel 2003 Excel 2007 Common Excel 2007
Command Equivalent Shortcut Keys Shortcut Keys
Tools➪Track Review | Track Alt+RG
Changes Changes
Tools
➪ Review | Protect Alt+RPS
Protection
➪ Sheet
Protect Sheet
Tools
➪ Review | Allow Users Alt+RU
Protection
➪ to Edit Ranges
Allow Users
to Edit Ranges
Tools
➪ Review | Protect Alt+RPW
Protection
➪ Workbook
Protect
Workbook
Tools
➪ Review | Protect Alt+RO
Protection
➪ Sharing
Protect and
Share Workbook
Tools➪Macro View | Macros Alt+F8 Alt+WM
Tools
➪Add-Ins Office Button | Excel Alt+FIAA and
Options | Add-Ins Alt+G
Tools
➪ Office Button | Excel Alt+FIPP and
AutoCorrect Options
| Proofing | Alt+A
Options AutoCorrect Options
Tools
➪Options Office Button | Excel Alt+FI
Options
Data Menu
Data➪Sort Data | Sort or Home | Sort Alt+AS or
& Filter | Custom Sort Alt+HSU
Data
➪Filter➪ Data | Filter Alt+AT
AutoFilter
Data
➪Filter➪ Data | Advanced Alt+AQ
Advanced Filter
Data
➪Form Available only as a
custom Form button
added to Quick Access
toolbar
(continued)
39
Chapter 1: The Excel 2007 User Experience
05_037377 ch01.qxp 11/16/06 9:23 AM Page 39