Excel
Page 1 of 7
Excel ShortCut Keys and Tips
Enter data by using shortcut keys
To
Press
Complete a cell entry
ENTER
Cancel a cell entry
ESC
Repeat the last action
F4 or CTRL + Y
Start a new line in the same cell
ALT + ENTER
Delete the character to the left of
the insertion point, or delete the
selection
BACKSPACE
Delete the character to the right of
the insertion point, or delete the
selection
DELETE
Delete text to the end of the line
CTRL + DELETE
Move one character up, down, left,
or right
Arrow keys
Move to the beginning of the line
HOME
Edit a cell comment
SHIFT + F2
Create names from row and
column labels
CTRL + SHIFT
+ F3
Fill down
CTRL + D
Fill to the right
CTRL + R
Fill the selected cell range with the
current entry
CTRL + ENTER
Complete a cell entry and move
down in the selection
ENTER
Complete a cell entry and move up
in the selection
SHIFT + ENTER
Complete a cell entry and move to
the right in the selection
TAB
Complete a cell entry and move to
the left in the selection
SHIFT + TAB
Work in cells or the formula bar by using
shortcut keys
To
Press
Start a formula
= (EQUAL SIGN)
Cancel an entry in the cell or
formula bar
ESC
Edit the active cell
F2
Edit the active cell and then clear
it, or delete the preceding
character in the active cell as you
edit the cell contents
BACKSPACE
Paste a name into a formula
F3
Define a name
CTRL + F3
Calculate all sheets in all open
workbooks
F9
Calculate the active worksheet
SHIFT + F9
Insert the AutoSum formula
ALT + = (EQUAL
SIGN)
Enter the date
CTRL + ;
(SEMICOLON)
Enter the time
CTRL + SHIFT + :
(COLON)
Insert a hyperlink
CTRL + K
Complete a cell entry
ENTER
Copy the value from the cell
above the active cell into the cell
or the formula bar
CTRL + SHIFT
+ " (QUOTATION
MARK)
Alternate between displaying cell
values and displaying cell
formulas
CTRL + ̀ (SINGLE
LEFT QUOTATION
MARK)
Copy a formula from the cell
above the active cell into the cell
or th