Excel Shortcuts

Ctrl + Space

Select the whole column

Shift + Space

Select the whole row

Ctrl + A / Ctrl + Shift + Space

Select all (Click once to select the current range, click twice to select the entire worksheet)

Ctrl + Shift + Arrow keys

Select a range - from the selected cell to the end of the range

Ctrl + Arrow keys

Go the end of the range

Alt + ; (Semicolon)

Select visible cell only

Ctrl + - (Minus)

Delete cells/rows/columns

Ctrl + Shift + =

Insert cells/rows/columns

CTRL + N

Open a new Workbook

Ctrl + O

Open an existing Workbook

Ctrl + S

Save Workbook (Or Save As, if it's the first time you're saving it)

F12

Save As (Even if you already saved it!)

CTRL + P

Print

CTRL + F4 / CTRL + W

Close Workbook

ALT + F4

Close Excel (All Workbooks)

Shift + F11

Add a new Worksheet

Ctrl + : (Colon)

Today's Date

Ctrl + D

Copy the cell above

Ctrl + R

Copy the cell to the left

F2

Edit cell/ view cell formula

F4

(When editing a specific cell) Apply absolute/mixed/relative reference (For example, cell C4 will change to $C$4 - Absolute Reference)

F7

Open the spelling tool

CTRL + E

Flash Fill - One of Excel's greatest tools for auto-completing data based on examples from adjacent cells.

Ctrl + C

Copy

Ctrl + V

Paste

Ctrl + X

Cut

Ctrl + Shift + V

Paste Special

Ctrl + ~ (Tilde)

Show all the formulas in the spreadsheet

F4

(When a cell is not being edited) Repeats the last action

Ctrl + Shift + Enter

Apply an array formula

Ctrl + T

Define range as data table

Alt + =

Quick sum

Ctrl + F

Find

Ctrl + H

Find and Replace

Ctrl + PgUp/PgDn

Navigate between sheets

Ctrl + Z

Undo last action

Ctrl + Y

Redo

Ctrl + [

Takes you to the cell referenced by the formula

Ctrl + ]

Takes you to the cell which is affected by the current cell

F5 , then Enter (not together)

Takes you back to where you were before using ctrl + [

Ctrl + Home / Ctrl + End

Go to the first cell in worksheet (A1) / Go to the last cell in the used range

Ctrl + Arrow Keys

Go to the last non-empty cell (Stops when you reach an empty cell)

Shift + Arrow Keys

Select cells in the direction of the Arrow Keys (One at a time)

Ctrl + Shift + Arrow Keys

Select cells until the last non-empty cell (Stops when you reach an empty cell)

F2

Edit the selected cell (instead of double-clicking it)

Shift + F2

Add a comment

Alt + Enter

Line break - Start a new line in the current cell

HOME

Go to the beginning of the current row within the cell which is being edited

Ctrl + HOME

Go to the beginning of the edited cell

END

Go to the end of the current row within the cell which is being edited

Ctrl + END

Go to the end of the edited cell

F9

Shows the result of the function/part of it (Based on what is selected)

Ctrl + 1

Open cell formatting window

CTRL + B

Bold text

CTRL + U

Underlined text

CTRL + I

Italic text

Italic text

Strikethrough

Ctrl + Shift + L

Apply filtering on the current range

ALT + F11

Open visual basic editor