The Most Important Microsoft Excel Shortcuts

CTRL and O = Open Workbook

CTRL and S = Save Workbook

CTRL and N = New Workbook

CTRL and P = Print

F12 = Save as

CTRL and F2 = Print Preview

ALT and F4 = Close Excel

CTRL and PG UP = Jumps to previous sheet

CTRL and DOWNWARD ARROW = Moves to last row of data

ALT and H and A and C = Align centre

ALT and H and A and L = Align left

ALT and H and A and R = Align right

CTRL and SHIFT and $ = Format-currency

CTRL and SHIFT and % = Format-percentage

CTRL and SHIFT and 6 = Format-scientific

CTRL and SHIFT and # = Format-date

CTRL and SHIFT and @ = Format-time

CTRL and SHIFT and 1 = Format-number

CTRL and R = Fill from cell right

CTRL and K = Add hyperlink

ALT and F1 = Create embedded chart

CTRL and / = Select current array

CTRL and SHIFT and * = Select around current cell

CTRL and K = Select current range

CTRL and SHIFT and RIGHT ARROW KEY = Select one word right

CTRL and SHIFT and LEFT ARROW KEY = Select one word left

CTRL and UPWARD ARROW KEY = Moves to first row of set

CTRL and RIGHT ARROW KEY = Move to one word on right

CTRL and LEFT ARROW KEY = Move to one word on left

CTRL and 1 = Opens format window

CTRL and 5 = Strikethrough

CTRL and B = Bold

CTRL and I = Italics

CTRL and U = Underline

CTRL and C = Copy

CTRL and V = Paste

CTRL and X = Cut

CTRL and Z = Undo

CTRL and Y = Redo

CTRL and F4 = Close workbook

CTRL and  ‘ = Copy formula from above cell

CTRL and * = Copy value from above cell

CTRL and D = Fill from above cell

SHIFT and END = Select to end cell

SHIFT and HOME = Select to beginning of cell

ESC = Quit selection

ALT and ENTER = New line in same cell

SHIFT and SPACE = New line in same cell

CTRL and  SPACE = Select table column

CTRL and A = Select all

CTRL and ; = Insert current date

CTRL and : = Insert current time