Excel 2007 For Dummies

In Microsoft Office Excel 2007, using the keystroke shortcuts (Alt + hot keys) instead of the ribbon will get you quickly through common view, file, and editing commands.

>

>

Shortcuts for Common File Commands in Excel 2007

Instead of using the ribbon for your basic file functions in Excel 2007, check out this chart for keystroke shortcuts ( Alt + hot key) to get your spreadsheet basic commands quickly accomplished.

Hot Keys	Excel Ribbon Command	Function
Alt+FN	Microsoft Office Button | New	Displays the New Workbook dialog box where you can open a blank workbook or one from a template
Alt+FO	Microsoft Office Button | Open	Displays the Open dialog box where you can select a new Excel workbook to open for editing or printing
Alt+FS	Microsoft Office Button | Save	Saves changes to a workbook. When you first select this command for a new workbook, Excel displays the Save As dialog box
Alt+FA	Microsoft Office Button | Save As	Display the Save As dialog box where you can modify the filename, location where the file is saved, and format that the file is saved in
Alt+FP	Microsoft Office Button | Print	Displays the Print dialog box to send the current worksheet, workbook, or cell selection to the printer
Alt+FE	Microsoft Office Button | Send	Sends the current workbook as an e-mail attachment or fax it using Internet Fax
Alt+FC	Microsoft Office Button | Close	Closes the current workbook without exiting Excel
Alt+FI	Microsoft Office Button | Excel Options	Displays the Excel Options dialog box where you can change default program settings and modify the buttons on the Quick Access toolbar
Alt+FX	Microsoft Office Button | Exit Excel	Quits the Excel program and closes all open workbooks after prompting you to save them

>

>

>

Common Editing Command Shortcuts in Excel 2007

As an alternative to using the ribbon in Excel 2007, these shortcut keystrokes (Alt + hot key) get you moving quickly through basic spreadsheet editing functions.

Hot Keys	Excel Ribbon Command	Function
Alt+HVP	Home | Paste | Paste	Pastes the currently cut or copied cell selection or graphic objects in the worksheet
Alt+HX	Home | Cut	Cuts the cell selection or selected graphic objects out of the workbook and places them on the Windows Clipboard
Alt+HC	Home | Copy	Copies the cell selection or selected graphic objects to the Windows Clipboard
Alt+FP	Home | Format Painter	Activates the Format Painter
Alt+FO	Home | Clipboard Dialog Box Launcher	Displays and hides the Clipboard task pane
Alt+HII	Home | Insert | Insert Cells	Opens Insert dialog box so you can indicate the direction in which to shift existing cells to make room for the ones being inserted
Alt+HIR	Home | Insert | Insert Sheet Rows	Inserts blank rows equal to the number of rows in the cell selection
Alt+HIC	Home | Insert | Insert Sheet Columns	Inserts blank columns equal to the number of columns in the cell selection
Alt+HIS	Home | Insert | Insert Sheet	Inserts a new worksheet in the workbook
Alt+HDD	Home | Delete | Delete Cells	Opens Delete dialog box so you can indicate the direction in which to shift existing cells to replace the ones being deleted
Alt+HDR	Home | Delete | Sheet Rows	Deletes rows equal to the number of rows in the cell selection
Alt+HDC	Home | Delete | Sheet Columns	Deletes columns equal to the number of columns in the cell selection
Alt+HDS	Home | Delete | Sheet	Deletes the current worksheet after warning you of data loss if the sheet contains cell entries
Alt+HEA	Home | Clear | Clear All	Clears the contents, formatting, and comments from the cell selection
Alt+HEF	Home | Clear | Clear Formats	Clears the formatting of the cell selection without removing the contents and comments
Alt+HEC	Home | Clear | Clear Contents	Clears the contents of the cell selection without removing the formatting and comments
Alt+HEM	Home | Clear | Clear Comments	Clears all comments in the cell selection without removing the formatting and contents

>

>

>

Shortcuts for Common View Commands in Excel 2007

If you want to change the way you're looking at an Excel 2007 spreadsheet, or the way the page is laid out, use these view command shortcuts (Alt + hot key).

Hot Keys	Excel Ribbon Command	Function
Alt+WN	View | Normal View	Returns the worksheet to normal view from Page Layout or Page Break Preview
Alt+WP	View | Page Layout View	Puts the worksheet into Page Layout View showing the page breaks, margins, and rulers
Alt+WI	View | Page Break Preview	Puts the worksheet into Page Break Preview showing pages breaks that you can adjust
Alt+WE	View | Full Screen	Puts the worksheet in full-screen mode which hides the Microsoft Office Button, Quick Access toolbar, and Ribbon - press the Esc key to restore previous viewing mode
Alt+WVG	View | Gridlines	Hides and redisplays the row and column gridlines that form the cells in the Worksheet area

>

>
dummies

Source:http://www.dummies.com/how-to/content/excel-2007-for-dummies-cheat-sheet.html