• New Excel Interface & Features
• Getting Started with Excel 2007
• Intro. to Formulas and Functions
• Intermediate Formulas/Functions
• Printing - Formatting - Saving
• Sorting, Filtering, & Tables
• Data Consolidation & Retrieval
• Security in Excel 2007

General


Ctrl + O	Open existing file
Ctrl + N	Create new workbook
Ctrl + S	Save current workbook
Ctrl + F4	Close current workbook
Ctrl + Z	Undo last action
Ctrl + Y	Redo last action
Ctrl + C	Copy selection
Ctrl + X	Cut selection
Ctrl + V	Paste selction
Ctrl + P	Print (displays print menu and options)
Ctrl + S	Save file
F12	Save file as

Entering Data


Enter	Complete cell data entry and move to cell below.
Ctrl + Shift + Enter	Enter/create array formula
Alt + Enter	Start new line in the same cell.
Ctrl + Enter	Fill selected cell range with current entry.
Shift + Enter	Complete cell data entry and move to cell directly above current cell.
Tab	Complete cell data entry and move to the cell to the right.
Shift + Tab	Complete cell data entry and move to the cell to the left.
Esc	Cancel a cell entry and go back to what was there before.
Arrow Keys	Move one cell left, right, up, or down.
Home	Move to the first column (A).
F4 / Ctrl + Y	Repeat last action.
Ctrl + Shift + F3	Create names for row and column labels.
Ctrl + D	Fill down.
Ctrl + R	Fill to the right.
Ctrl + F3	Define a name for a cell or range of cells.
Ctrl + K	Insert a hyperlink.
Enter (after insertion of hyperlink)	Activate a hyperlink.
Ctrl + ;	Enter the current date.
Ctrl + Shift + :	Enter the current time.
Alt + Down Arrow	Display a drop-down list of the values in the current column of a list.
Ctrl + Z	Undo the last action.
Alt + F8	Displays macro dialog box.
Alt + F11	Displays the visual basic editor.
Ctrl + F11	Inserts an Excel 4.0 macro sheet.

Edit Data


F2	Edit highlighted cell - cursor is at the end of cell contents.
Alt + Enter	Start a new line in the same cell.
Backspace	When cell is highlighted, deletes cells contents.
Delete	Deletes cells contents if cell is highlighted.
Ctrl + Delete	Deletes text to the end of the line.
F7	Runs spell-check.
Shift + F2	Inserts and edits comments.
Enter	Completes cell entry and moves to cell below.
Ctrl + Z	Undo last action.
Esc	Cancel a cell entry, previous contents are restored.
Ctrl + Shift + Z	When the autocorrect smart tags is displayed, undo or redo the last automatic correction.
Ctrl + C + Ctrl + C	Displays the clipboard (where copied items are).
Ctrl + -	Removes/deletes selected cells from the sheet.
Ctrl + Shift + "+"	Inserts blank cells.

Format Data


Alt + '	Display style dialog box.
Ctrl + 1	Display format cells dialog box.
Shift + Spacebar	Highlight row
Ctrl + Spacebar	Highlight column
Ctrl + Shift + ~	Apply the 'general number' format to selected cells.
Ctrl + Shift + $	Apply the 'currency number' format with two decimal places and negative numbers showing in parentheses to selected cells.
Ctrl + Shift + %	Apply the 'percentage' format with no decimal places to selected cells.
Ctrl + Shift + ^	Apply the 'exponential number' format with two decimal places to selected cells.
Ctrl + Shift + #	Apply the 'date' format with the day, month, and year to selected cells.
Ctrl + Shift + @	Apply the 'time' format with the hour, minute, and AM or PM to selected cells.
Ctrl + Shift +!	Apply the 'number' format with two decimal places, thousands seperator, and minus sign for negative numbers to selected cells.
Ctrl + B	Apply/remove bold format to selected cells.
Ctrl + I	Apply/remove italic format to selected cells.
Ctrl + U	Apply/remove underline to selected cells.
Ctrl + 5	Apply or remove 'strikethrough' to selected cells.
Ctrl + 8	Displays or hides the outline of symbols.
Ctrl + 9	Hide row.
Ctrl + Shift + 9	Unhide row.
Ctrl + Shift + (	Unhide any hidden rows within the selection.
Ctrl + 0	Hide the selected columns.
Ctrl + Shift + )	Unhide any columns within the selection.
Ctrl + Shift + &	Apply the 'border outline' to selcted cells.
Ctrl + Shift + _	Remove the 'border outline' from selected cells.
Alt + Shift + Right Arrow	Groups selected rows or columns.
Alt + Shift + Left Arrow	Ungroups selected rows or columns.

Macros


Alt + F8	Displays macro dialog box.
Alt + F11	Displays the visual basic editor.
Ctrl + F11	Inserts an Excel 4.0 macro sheet.