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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- free excel tutorial download pdf
- printable excel tutorial in pdf
- microsoft excel tutorial pdf download
- free basic excel tutorial pdf
- free microsoft excel tutorial pdf
- excel tutorial pdf 2018
- basic excel tutorial pdf
- excel tutorial pdf free download
- free excel tutorial for beginners
- excel tutorial for beginners pdf
- ms excel tutorial free pdf