excel shortcut..

Excel Keyboard ShortcutsUndocumented Shortcuts F2 F9 Evaluate the formula Select part of a formula and hit F9 Evalutates only that part CTRL + Drag Frame around selection Drag + Copy Shift + Drag Frame Drag and Insert Select Row or Column and Drag Frame Moves Row (can overwrite other rows) Select Row or Column and Drag Frame with SHIFT Inserts Row in new postion Select Row or Column and Drag Frame with CTRL Inserts COPY of Row in new postion

LEGENDBlue = Useful Shortcut Green = Uses Shift for "Anchor" or Ctrl for "More"

Shortcuts for Selecting cells and regions CTRL+SPACEBAR Select the entire column. SHIFT+SPACEBAR Select the entire row. CTRL+A Select the entire worksheet. SHIFT+BACKSPACE With multiple cells selected, select only the active cell. CTRL+SHIFT+SPACEBAR With an object selected, select all objects on a sheet. CTRL+6 Alternate between hiding objects, displaying objects, and displaying placeholders for objects. CTRL+SHIFT+* (asterisk) Select the current region around the active cell (solid block) CTRL+/ Select the array containing the active cell. CTRL+SHIFT+O (the letter O) Select all cells that contain comments. CTRL+\ In a selected row, select the cells that don't match the value in the active cell. CTRL+SHIFT+| In a selected column, select the cells that don't match the value in the active cell. CTRL+[ (opening bracket) Select all cells directly referenced by formulas in the selection. CTRL+SHIFT+{ (opening brace) Select all cells directly or indirectly referenced by formulas in the selection. CTRL+] (closing bracket) Select cells that contain formulas that directly reference the active cell. CTRL+SHIFT+} (closing brace) Select cells that contain formulas that directly or indirectly reference the active cell.

Excel Keyboard Shortcuts

Undocumented Shortcuts

F2 F9

Evaluate the formula

Select part of a formula and hit F9

Evalutates only that part

CTRL + Drag Frame around selection

Drag + Copy

Shift + Drag Frame

Drag and Insert

Select Row or Column and Drag Frame

Moves Row (can overwrite other rows)

Select Row or Column and Drag Frame with SHIFT

Inserts Row in new postion

Select Row or Column and Drag Frame with CTRL

Inserts COPY of Row in new postionShortcuts for Selecting cells and regions

CTRL+SPACEBAR

Select the entire column.

SHIFT+SPACEBAR

Select the entire row.

CTRL+A

Select the entire worksheet.

SHIFT+BACKSPACE

With multiple cells selected, select only the active cell.

CTRL+SHIFT+SPACEBAR

With an object selected, select all objects on a sheet.

CTRL+6

Alternate between hiding objects, displaying objects, and displaying placeholders for objects.

CTRL+SHIFT+* (asterisk)

Select the current region around the active cell (solid block)

CTRL+/

Select the array containing the active cell.

CTRL+SHIFT+O (the letter O)

Select all cells that contain comments.

CTRL+\

In a selected row, select the cells that don't match the value in the active cell.

CTRL+SHIFT+|

In a selected column, select the cells that don't match the value in the active cell.

CTRL+[ (opening bracket)

Select all cells directly referenced by formulas in the selection.

CTRL+SHIFT+{ (opening brace)

Select all cells directly or indirectly referenced by formulas in the selection.

CTRL+] (closing bracket)

Select cells that contain formulas that directly reference the active cell.

CTRL+SHIFT+} (closing brace)

Select cells that contain formulas that directly or indirectly reference the active cell.

excel shortcut..

ALT+; (semicolon)

Select the visible cells in the current selection

F8

Turn extend mode on or off. In extend mode, EXT appears in the status line.

SHIFT+F8

Add another range of cells to the selection

SHIFT+arrow key

Extend the selection by one cell.

CTRL+SHIFT+arrow key

Extend the selection to the last nonblank cell in the same column or row as the active cell.

SHIFT+HOME

Extend the selection to the beginning of the row.

CTRL+SHIFT+HOME

Extend the selection to the beginning of the worksheet.

CTRL+SHIFT+END

Extend the selection to the last used cell on the worksheet (lower-right corner).

SHIFT+PAGE DOWN

Extend the selection down one screen.

SHIFT+PAGE UP

Extend the selection up one screen.

END+SHIFT+arrow key

Extend the selection to the last nonblank cell in the same column or row as the active cell.

END+SHIFT+HOME

Extend the selection to the last used cell on the worksheet (lower-right corner).

END+SHIFT+ENTER

Extend the selection to the last cell in the current row.

SCROLL LOCK+SHIFT+HOME

Extend the selection to the cell in the upper-left corner of the window.

SCROLL LOCK+SHIFT+END

Extend the selection to the cell in the lower-right corner of the window.

Entering, Editing, Formatting & Calculating Information

ENTER

Complete a cell entry (and move to another cell unless "Move Selection After Enter" is turned off).

ALT+ENTER

Start a new line in the same cell.

CTRL+ENTER

Fill the selected cell range with the current entry.

SHIFT+ENTER

Complete a cell entry and select the previous cell above.

TAB

Complete a cell entry and select the next cell to the right.

SHIFT+TAB

Complete a cell entry and select the previous cell to the left.

ESC

Cancel a cell entry.

Arrow keys

Move one character up, down, left, or right.

HOME

Move to the beginning of the line.