GENERAL EXCEL KEYS
CELL EDIT MODE
ENTERING DATA
FORMATTING DATA /
BORDERS
WORKBOOK / OTHER
100

How to open "Help" ?

F1

100

How to "Insert or edit a Comment"

Shift + F2

100
How to "Move Up a Cell"

SHIFT + ENTER

100
How to "Format Anything"

CTRL + 1

100

How to "Open Spelling Dialogue Box"

F7

200
How to "Cut selected cells"

CTRL + X

200

How to "Move 1 word Right"

CTRL + ->

200

How to "Enter same Data in Mulitple Cells"

CTRL + ENTER

200

How to "Apply Currency Format"

CTRL + SHIFT + $

200

How to "Duplicate Previous Cell"

Ctrl + D

300
How to "Toggle Auto-Filter"

CTRL + SHIFT + L

300
How to "Delete to END of line"

CTRL + DELETE

300

How to "Insert Current Date"

CTRL + ;

300

How to "Add Border Outline"

CTRL + SHIFT + &

300

How to "Go To Next Work Book"

CTRL + PGDN

400
How to "Insert Table"

CTRL + T

400
How to "Delete the character to the left of mouse"

BACKSPACE

400
How to "Copy Formula from Cell Above"

CTRL + '

400

How to "Remove Border Outline"

CTRL + SHIFT + _

400

How to "Move to Next Pane"

F6

500

How to "Move Cell Right"

CTRL + ALT + ->

500
How to add "New line in Cell"

ALT + ENTER

500

How to "Add Hyperlink"

CTRL + K

500
How to "Remove BOLD Formatting"

CTRL + B

500
How to "Add Pivot Chart on new Worksheet"

F11

M
e
n
u