Excel Tutorial: Short-Cuts



Excel Tutorial: Short-Cuts

The following are the most frequently used keyboard “short-cuts” for Excel. It is significantly faster to use Excel if you don’t use the mouse!

Navigation

| | Command |Description |

| | |Move to adjacent cell |

|Move: |[arrow keys] | |

| | | |

| | | |

| | |Move to end of data in |

|Move quickly: |+ [arrow keys] |column/row, or next data if on |

| | |empty cell |

| | |Moves to first column, or first|

|First Column: | |column after freeze pane |

| | |Go to the first cell in the |

|First Cell: |+ |current worksheet or freeze |

| | |pane |

| | |Go to the last cell in the |

|Last Cell: |+ |current worksheet |

| | |Switch to next/previous sheet |

|Change Sheet: |+ / |in workbook |

| | |Adjust zoom level for selected |

|Zoom: |+ ; |sheets |

Editing

| | Command |Description |

| | |Edit current cell |

|Edit Cell: | | |

| | |Change method of cell reference|

|Cell Reference: | |while currently editing cell |

| | |Switch cursor to formula bar, |

|Edit formula bar: |+ |while currently editing cell |

| | |Exit from edit mode |

|Cancel / Accept: |/ |without/with accepting changes |

| | |Undo last action |

|Undo: |+ | |

| | |Redo last undone action, or |

|Redo: |+ |redo new action |

| | |Go to adjacent cell, |

|Next Cell: | |remembering start (use enter |

| | |for next line) |

| | |Insert a whole row / column |

|Insert Row/Col: |+ ; / | |

| | |Delete whole row / column or |

|Delete Row/Col |+ ; |cells |

| | |Select data (adjacent cells) |

|Select: |+ [arrow keys] | |

| | |Select to end of data in |

|Select quickly: |+ + [arrow keys] |column/row, or next data if on |

| | |empty cell |

| | |Selects whole row |

|Select Row: |+ | |

| | |Selects whole column |

|Select Column: |+ | |

| | |Copy selected cells |

|Copy: |+ | |

| | |Paste formatting/column |

|Paste Special: |+ ; |width/values/etc. |

| | |Copy first selected formula |

|Copy down: |+ |down (through selection) |

| | |Copy first selected formula |

|Copy right: |+ |right (through selection) |

| | | |

|Select adjacent: |+ + | |

| | |Select next sheet with current |

|Select Next Sht: |+ + |to make simultaneous changes |

| | |As per Select Next Sheet |

|Select Prev Sht: |+ + | |

|Tip for symbols: |

| |

|If you need to insert a symbol, get it from Word and copy it over to Excel. Use ALT + I |

|then S to get the symbols selection box. If it’s a regularly used symbol, then assign a |

|short-cut key to it from within the selection box. |

Formatting

| | Command |Description |

| | |Opens format box, applies to |

|Format Cell: |+ |selected cells |

| | |Sets (or removes) freeze pane |

|Set Freeze Pane: |+ ; |to (from) current cell location|

| | |Change sheet name, hit enter |

|Edit Sheet name: |+ ; ; |when finished |

| | |Shows or removes grid lines on |

|Set Grid lines: |+ ; |selected sheets |

| | | |

| |+ ; | |

| | |Set selected rows to height of |

|Hide Rows |+ |0 |

| | |Set selected columns to height |

|Hide Columns |+ |of 0 |

Cross-checking

| | Command |Description |

| | |Show cell references (use CTRL+|

|See References: |+ |] to hide, or arrow keys) |

| | |Show precedents |

|Audit/trace: |+ ; ; | |

| | |Show dependents |

|Audit/trace: |+ ; ; | |

| | |Remove trace |

|Audit/trace: |+ ; ; | |

| | |Sum the adjacent |

|Auto-sum: |+ |horizontal/vertical line |

| | |Show/hide formulae (~ is |

|Show Formulae: |+ |adjacent to the 1 key) |

General

| | Command |Description |

| | |Edit calculation mode, |

|Options: |+ ; |show/hide gridlines, show/hide |

| | |formulae |

| | |Define/edit/delete named ranges|

|Named Range: |+ ; ; | |

| | |Close the current workbook |

|Close Sheet: |+ ; | |

| | |Show page setup options for |

|Print Options: |+ ; |currently selected sheet(s) |

| | Command |Description |

| | | |

| | | |

| | | |

| | | |

| | | |

| | | |

| | | |

| | | |

| | | |

| | | |

| | | |

| | | |

| | | |

| | | |

| | | |

| | | |

| | | |

| | | |

| | | |

| | | |

| | | |

| | | |

| | | |

| | | |

| | | |

| | | |

| | | |

| | | |

| | | |

| | | |

| | | |

| | | |

| | | |

| | | |

| | | |

| | | |

-----------------------

FINANCE CLUB

CTRL

SHIFT

Pg Up

CTRL

SHIFT

Pg Dn

CTRL

SPACE BAR

SHIFT

SPACE BAR

D

C

CTRL

Pg Dn

CTRL

END

CTRL

HOME

Esc

F2

CTRL

1

O

W

F

CTRL

9

ALT

V

Z

CTRL

A

R

O

ALT

H

ALT

T

ALT

Enter

G

ALT

O

T

ALT

I

N

D

ALT

Pg Dn

Pg Up

SHIFT

CTRL

SHIFT

TAB

HOME

CTRL

0

CTRL

F4

Enter

ALT

I

R

C

Pg Up

E

ALT

CTRL

S

E

ALT

ALT

T

CTRL

[

CTRL

Z

Y

CTRL

D

CTRL

R

CTRL

8

SHIFT

CTRL

U

D

C

F

ALT

U

F

ALT

U

T

T

ALT

ALT

T

U

A

=

ALT

~

CTRL

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download