Excel 2007 Keyboard Shortcuts

Here are the Excel 2007 Keyboard Shortcuts.

Navigating a Document

Arrow keys	Move left, right, up, or down one cell.
Home	Move to the beginning of the row.
Page Down	Move down one screen.
Page Up	Move up one screen.
Alt+Page Down	Move one screen to the right.
Alt+Page Up	Move one screen to the left.
Ctrl+Home	Move to the beginning of the worksheet.
Ctrl+End	Move to the bottom, right corner of the used portion of the worksheet.
Ctrl+arrow keys	Move in the direction of the arrow to the next nonblank cell if the current cell is blank or to the last nonblank cell if the current cell isnonblank.
Ctrl+Backspace	Scroll the worksheet to bring the active cell of the current selection into view.
F5 or Ctrl+G	Open the Go To dialog box.
Ctrl+Page Up	Move to the previous worksheet.
Ctrl+Page Down	Move to the next worksheet.

Selecting Data

Shift+navigation key	Move the active cell as dictated by the navigation key (see “Navigating a Worksheet”) and also extend the current selection to that point.
Ctrl+*	Select the rectangular area that includes every cell adjacent to the current cell.
Ctrl+Spacebar	Select the entire column (or columns) that contains the active cell (or cells).
Shift+Spacebar	Select the entire row (or rows) that contains the active cell (or cells).
F8	Toggle extend mode on and off. (When extend mode is on, use the navigation keys to extend the selection.)
Shift+F8 Toggle	add mode on and off. (When add mode is on, select a cell or range to add it to the current selection.)
Ctrl+Shift+O	Select all the cells in the current worksheet that contain comments.
Ctrl+/	Select the array containing the active cell.
Ctrl+\	Select the cells that don’t match the active cell in the current horizontal selection.
Ctrl+|	Select the cells that don’t match the active cell in the current vertical selection.
Ctrl+[	Select the cells directly referenced by the formula in the active cell.
Ctrl+{	Select the cells directly or indirectly referenced by the formula in the active cell.
Ctrl+]	Select the cells with formulas that directly reference the active cell.
Ctrl+}	Select the cells with formulas that directly or indirectly reference the active cell.
Ctrl+A	Select the rectangular area that includes every cell adjacent to the active cell.
Press Ctrl+A	again to select the entire worksheet.B

Moving the Active Cell in a Selection

Enter	Move the active cell down rows and left-to-right across columns.
Shift+Enter	Move the active cell up rows and right-to-left across columns.
Tab	Move the active cell left-to-right across columns and down rows.
Shift+Tab	Move the active cell right-to-left across columns and up rows.
Ctrl+.	Move the active cell clockwise from corner to corner.
Ctrl+Alt+right arrow	Move the active cell to the next noncontiguous selection to the right.
Ctrl+Alt+left arrow	Move the active cell to the next noncontiguous selection to the left.

Editing a Worksheet

F2	Edit the active cell.
Shift+F2	Insert or edit a comment in the active cell.
Alt+=	Enter an AutoSum formula into the current cell.
Alt+Enter	Insert a carriage return in a cell formatted with wrapped text.
Ctrl+Enter	Fill the selected cells with the contents of the Formula Bar.
Ctrl+Shift+Enter	Enter the contents of the Formula Bar into the current cell as an array formula.
Ctrl+Shift+U	Toggle the expanded version of the Formula Bar on and off.
Ctrl+`	Toggle the worksheet between showing formulas and cell values.
Ctrl++	Insert an entire row or column before the currently selected row or column.
Ctrl+–	Delete the currently selected row or column.
Ctrl+;	Insert the current date.
Ctrl+:	Insert the current time.
Ctrl+’	Copy the contents from the cell directly above the current cell.
Ctrl+”	Copy the value of the cell directly above the current cell.
Ctrl+<	Copy the contents from the cell directly above the current cell and adjust cell references.
Ctrl+>	Copy the contents from the cell directly to the left of the current cell and adjust cell references.
Ctrl+A	Open the Function Arguments for the current function (place the cursor to the right of the function name before pressing Ctrl+A).
Ctrl+Shift+A	Insert a function’s arguments into the current cell (place the cursor to the right of the function name before pressing Ctrl+Shift+A).
Ctrl+D	Fill the contents and formatting of the topmost cell in the current vertical selection down to the rest of the cells in the selection.
Ctrl+R	Fill the contents and formatting of the leftmost cell in the current horizontal selection right to the rest of the cells in the selection.
Ctrl+T	Open the Create Table dialog box.
F3	Open the Paste Names dialog box.
Shift+F3	Open the Insert Function dialog box.
Ctrl+Shift+F3	Open the Create Names from Selection dialog box.
Shift+F11	Insert a new worksheet.
F11	Insert a new chart sheet and create a chart from the current selection.

Formatting Text

Ctrl+1	Open the Format Cells dialog box with the most recently used tab displayed.
Ctrl+5	Apply strikethrough to the current selection.
Ctrl+6	Toggle objects on and off.
Ctrl+8	Toggle outlining symbols on and off.
Ctrl+9	Hide the row or rows containing the current selection.
Ctrl+(	Unhide any rows that lie in the current selection.
Ctrl+0	Hide the column or columns containing the current selection.
Ctrl+)	Unhide any columns that lie within the current selection.
Ctrl+&	Apply an outline border to the selection.
Ctrl+_	Remove an outline border from the selection.
Alt+’	Open the Style dialog box.
Alt+Shift+right arrow	Group the selected rows or columns for an outline.
Alt+Shift+left arrow	Ungroup the selected rows or columns for an outline.
Ctrl+Shift+F	Open the Format Cells dialog box with the Font tab displayed.
Ctrl+Shift+D	Apply double underline to the current selection.
Ctrl+5	Apply strikethrough to the current selection.
Ctrl+~	Apply the General format to the current selection.
Ctrl+!	Apply the Number format (two decimal places; using thousands separator) to the current selection.
Ctrl+$	Apply the Currency format (two decimal places; using dollar sign; negative numbers surrounded by parentheses) to the current selection.
Ctrl+%	Apply the Percentage format (zero decimal places) to the current selection.
Ctrl+^	Apply the Scientific format (two decimal places) to the current selection.
Ctrl+#	Apply the Date format (d-mmm-yy) to the current selection.
Ctrl+@	Apply the Time format (h:mm AM/PM) to the current selection.

Working with Workbooks and Windows

F9	Recalculate all open workbooks.
Shift+F9	Recalculate the active worksheet.
Ctrl+Alt+Shift+F9	Recalculate all open workbooks, even formulas that are unchanged since the previous calculation.
Ctrl+F9	Minimize the current window.
Ctrl+F5	Restore the current window.