top of page

Shortcuts

Delete

  • All formatting ⇒  ALT + E + A + A

  • Column(s) ⇒  Highlight column(s) + CTRL + '-

  • Row(s) ⇒ Highlight row(s) + CTRL + ‘-‘

​

  • Duplicate a worksheet ⇒ Click on the sheet to copy and hold + CTRL + drag (ADD VIDEO)

Insert

  • Column(s) ⇒ Highlight a column(s), CTRL + ‘+’

  • Current date ⇒  CTRL + ;

  • Current time ⇒  CTRL + SHIFT + ;

  • Insert ‘$’ to cell reference (locked cell) ⇒ F4

  • Insert / Edit a comment to a cell ⇒ SHIFT + F2

  • Row(s) ⇒ Highlight row(s) + CTRL + ‘+’

  • PivotTable ⇒  ALT + N + V.  To learn more about pivot tables, click here.

Column

  • Delete column(s) ⇒ Highlight column(s) + CTRL + '-'

  • Insert column(s) ⇒ Highlight column(s) + CTRL + '+'

​

Comments

  • Insert / Edit a comment to a cell ⇒ SHIFT + F2

  • Show / Hide all comments ⇒  ALT + V +C

​

  • Convert data into a table ⇒ Click on a cell that contains the data + CTRL + T

  • Copy a worksheet ⇒ Click on the sheet to copy and hold + CTRL + drag (ADD VIDEO)

  • Access "Format Cells" dialog box ⇒ CTRL + '1'​

Edit

  • A cell ⇒  F2

  • A comment ⇒  SHIFT + F2

C
A
D
E
S
I
T
B

  • Filter on / off ⇒  CTRL + SHIFT + L

  • Go to the top / bottom of data ⇒ CTRL + 'up arrow / down arrow'

  • Group sheets ⇒ CTRL + SHIFT + ⇒

F
G

  • Highlight data ⇒  Click on a cell + CTRL + SHIFT + 'up arrow / down arrow' (depending if you want to highlight a column or row)

  • Highlight entire row ⇒  SHIFT + SPACE

H
K
J
L

  • Merge and centre ⇒ Highlight cell(s), ALT + H + M + C

 

Move

  • Between excel spreadsheets ⇒ CTRL + TAB

  • To another sheet ⇒ CTRL + ‘pg up / pg dn'

M

Paste 

  • Paste Special Formulas ⇒ CTRL + ALT + V + F

  • Paste Special Formulas & Transpose ⇒ CTRL + ALT + V + F + E

  • Paste Special Formats ⇒ CTRL + ALT + V + T

  • Paste Special Formats & Transpose ⇒ CTRL + ALT + V + T + E

  • Paste Special Values ⇒ CTRL + ALT + V + V

  • Paste Special Values & Transpose ⇒ CTRL + ALT + V + V + E

​

Pivot Table

  • Insert Pivot Table ⇒ ALT + N + V

N
P
O

  • Re-do undo ⇒ CTRL + Y

​

Row

  • Highlight entire row ⇒ SHIFT + L

  • Delete row(s) ⇒ Highlight row(s) + CTRL + '-'

  • Insert row(s) ⇒ Highlight column(s) + CTRL + '+'

R
Q

  • Scroll to the top / bottom of data ⇒ CTRL + 'up arrow / down arrow'

  • Sum a column ⇒ ALT + '+='

​

  • Filter on / off ⇒  CTRL + SHIFT + L

  • Undo ⇒ CTRL + Z

  • Unmerge cell(s) ⇒ Highlight cell(s), ALT + H + M + C

  • Unwrap text ⇒ Highlight cell(s), ALT + H + W

U

  • Wrap text ⇒ Highlight cell(s) + ALT + H + W

V
W
X
Y
Z
bottom of page