Useful Shortcuts

You can save a lot of time if you learn a few keyboard shortcuts in Excel. Don’t try to learn all in one day, then you’ll forget them just as fast. I think the best way to learn them all would be to bookmark this page and come back here a couple of times a week.

Common shortcuts

Many shortcuts in Excel are the same as in other Microsoft programs:

Copy: Ctrl+C

Cut: Ctrl+X

Paste: Ctrl+V

Bold: Ctrl+B

Italic: Ctrl+I

Underline: Ctrl+U

Find: Ctrl+F

Replace: Ctrl+H

Go to: Ctrl+G

Insert hyperlink: Ctrl+K

Close window: Ctrl+W

Undo: Ctrl+Z

Redo: Ctrl+Y

Close application: Alt+F4

Excel specific shortcuts

When you work with Microsoft Excel, you can save even more time if you learn these:
IMPORTANT: It is impossible to learn these shortcuts unless you actually try them out and practice!

Switch to edit mode in a cell: F2

Lock a cell reference (A1 => $A$1): F4

Navigate in the worksheet: Ctrl + Arrow key moves to the edge of the current data region in the worksheet.