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

E-mail Address:

Industry:

Job Title:

Company Size:

Country:

State:

I would like to receive offers via e-mail from Computerworld partners.

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

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

Print this Story

Send Us Feedback

Digg this Story

Slashdot this Story

What People Are Saying

7 comments | Add new

View all comments (7) | Add a comment

	Mitch Wagner: Google Buzz buzzkill
	Researchers warn of likely attacks against Windows, PowerPoint
	Panasonic takes swing at rugged rivals, launches latest Toughbook tablet
	More top stories...

	Court to review standards for cell phone data requests
	New Russian botnet tries to kill rival
	Chinese artist-dissident lauds Google plan to stop censoring

Top 10 Super Bowl tech ads

Watch the most compelling Super Bowl ads of years past from the likes of Intel, Iomega, EDS, Apple and Xerox, then vote for your favorite in our reader poll.

Is NAND flash about to hit a dead end?

As the technology used to create NAND flash memory continues to shrink, bit error rates and reliability issues are increasing, forcing solid-state memory makers to look for alternatives.