Editor's note: These charts accompany our story Excel 2007 Cheat Sheet. Click through to that story for detailed information on getting up and running with Excel 2007.
Wondering where your favorite Excel 2003 commands went? Worry no more. Just use these quick reference charts, which list the most commonly used Excel 2003 commands and tell you where they are in Excel 2007. 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 Excel 2003 and Excel 2007; we've noted where they differ.
For a full listing of every menu and submenu item, download the Excel Ribbon mapping workbook from Microsoft Corp. The company also lists more Excel 2007 keyboard shortcuts on its Office Online Web site.
File Menu | Edit Menu | View Menu | Insert Menu | Format Menu | Tools Menu | Data Menu | Window Menu
File Menu
Excel 2003 Location | Excel 2007 Location | Keyboard Shortcut |
File > New | Office button > New | Ctrl-N |
File > Open | Office button > Open | Ctrl-O |
File > Close | Office button > Close | Ctrl-W |
File > Save | Office button > Save or Quick Access tool bar > Save icon | Ctrl-S |
File > Save As | Office button > Save As | F12 |
File > Save As Web Page | Office button > Save As (in Save As dialog, choose Web Page from Save As Type drop-down) | In Excel 2003: Alt-F, G In Excel 2007: F12 (in Save As dialog, choose Web Page from Save As Type drop-down) |
File > Save Workspace | View > Window > Save Workspace | In Excel 2003: Alt-F, W In Excel 2007: Alt-W, K |
File > File Search | Windows Start button > Search | In Excel 2003: Alt-F, H In Excel 2007: Window key, C |
File > Permission | Office button > Prepare > Restrict Permission | In Excel 2003: Alt-F, M In Excel 2007: Alt-F, E, R |
File > Web Page Preview | Add to Quick Access tool bar: Office button > Excel Options > Customize > All Commands > Web Page Preview | In Excel 2003: Alt-F, B In Excel 2007: Alt-[number of position in Quick Access tool bar] |
File > Page Setup | Page Layout > Page Setup (click dialog box launcher for more options) or Office button > Print > Print Preview > Page Setup icon | In Excel 2003: Alt-F, U In Excel 2007: Alt-P, SP |
File > Print Area | Page Layout > Page Setup > Print Area | In Excel 2003: Alt-F, T In Excel 2007: Alt-P, R |
File > Print Preview | Office button > Print > Print Preview | In Excel 2003: Alt-F, V In Excel 2007: Alt-F, W, V |
File > Print | Office button > Print | Ctrl-P |
File > Send To | Office button > Send (for more Send options, see Office button > Excel Options > Customize > All Commands) | Alt-F, D |
File > Most Recently Used Documents | Office button > Recent Documents | Alt-F |
Return to Excel 2007 Cheat Sheet