Ads by TechWords

See your link here
Receive the latest technology news and information.
Computerworld Daily News (First Look and Wrap-Up)
Computerworld Blogs Newsletter
The Weekly Top 10
Cloud Computing
View all newsletters




Privacy Policy
 

Excel 2007 Cheat Sheet: Quick reference charts

Find your favorite Excel 2003 commands in the new Excel 2007 interface
Computerworld staff   Today’s Top Stories   or  Other Software Stories  

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 > NewOffice button > NewCtrl-N
File > OpenOffice button > OpenCtrl-O
File > CloseOffice button > CloseCtrl-W
File > SaveOffice button > Save
or
Quick Access tool bar > Save icon
Ctrl-S
File > Save AsOffice button > Save AsF12
File > Save As Web PageOffice 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 WorkspaceView > Window > Save WorkspaceIn Excel 2003: Alt-F, W
In Excel 2007: Alt-W, K
File > File SearchWindows Start button > SearchIn Excel 2003: Alt-F, H
In Excel 2007: Window key, C
File > PermissionOffice button > Prepare > Restrict PermissionIn Excel 2003: Alt-F, M
In Excel 2007: Alt-F, E, R
File > Web Page PreviewAdd to Quick Access tool bar: Office button > Excel Options > Customize > All Commands > Web Page PreviewIn Excel 2003: Alt-F, B
In Excel 2007: Alt-[number of position in Quick Access tool bar]
File > Page SetupPage 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 AreaPage Layout > Page Setup > Print AreaIn Excel 2003: Alt-F, T
In Excel 2007: Alt-P, R
File > Print PreviewOffice button > Print > Print PreviewIn Excel 2003: Alt-F, V
In Excel 2007: Alt-F, W, V
File > PrintOffice button > PrintCtrl-P
File > Send ToOffice button > Send
(for more Send options, see Office button > Excel Options > Customize > All Commands)
Alt-F, D
File > Most Recently Used DocumentsOffice button > Recent DocumentsAlt-F

Return to Excel 2007 Cheat Sheet

 

Print this Story Send Us Feedback Digg! Digg this Story Slashdot this Story


Sign up to receive Software Resource Alerts

sign-up

What People Are Saying

IE9 to tap hardware to boost performance
New attack fells Internet Explorer
The 5 best and worst features of Google Chrome OS
More top stories...
Free Web apps to help organize your holidays
Google's Chrome OS hits BitTorrent
Global warming research exposed after hack
Getting to know Windows 7? Don't stop now: From speeding up taskbar thumbnails to reining in UAC, here are 20 ways to make Windows 7 act the way you want.
Is Motorola's new Droid good enough to vanquish iPhone envy? To find out, we took it on a 3-day trip.
Sure, you could always use Linux as a desktop OS, but Corel Linux 1.0 was the first distro designed for ordinary users. It's been a long, strange trip since then.
New touch-screen laptops from Fujitsu, HP and Lenovo take advantage of Microsoft Windows 7's touch-friendly infrastructure.
"Some people are disappointed that Google's Chrome plans don't include a head-to-head fight for the desktop with Windows. They shouldn't..." Read more...
"Google's vision for Chrome OS isn't going to replace what is on your desk now...unless you are working and reading..." Read more...
Read more Software posts or See all Blogs

Ads by TechWords

See your link here
Get the latest news, reviews and more about Microsoft's newest desktop operating system.
General Mills, Genentech, San Diego Gas & Electric, University of Pennsylvania and Monsanto top the list.