Excel Shortcuts Flashcards
Add or edit a cell comment
Shift + F2
Alignment
Alt + H, A, (L, C, R)
Apply currency format with two decimal places
Ctrl + Shift + S
Apply general number format
Ctrl + Shift + ~
Apply percent format without decimal places
Ctrl + Shift + %
Beginning of a worksheet
Ctrl + Home
Esc
Cancel current cell entry
Choose a fill color
ALT + H, H
Redo the last command
Ctrl + Y
Context menu
Shift + F10
Copy value from above
Ctrl + Shift + “
Create a chart of the data
F11
Copy formula from above
Ctrl + ‘
Data tab
Alt + A
Date format
Ctrl + Shift + #
Define a name
Alt + M, M, D
Delete border
Ctrl + Shift + _
Delete cells, row, column, sheet
Alt + H, D, (D, R, C, S)
Delete selected cells
Ctrl + Minus
Edit active cell at the end of the formula bar
F2
Extend or collapse the formula bar
Ctrl + Shift + U
Extend Selection
Shift + Arrow Key