top of page

The Complete Excel Shortcut Keys Guide



Excel cartoon


  • Ctrl + Shift + ; Enter the current time

  • Ctrl + ; Enter the current date

  • Alt + Shift +F1 Insert new worksheet

  • Shift + F3 Open the Excel formula window

  • Shift +F5 Bring up search box

  • Ctrl + Tab Switch between two or more open Excel files

  • Alt + = Create a formula to sum all of the above cells

  • Ctrl + ' Insert the value of the above cell into the current cell

  • Ctrl + Shift + ! Format number in comma and decimal form

  • Ctrl + Shift + $ Format number in currency form

  • Ctrl + Shift + # Format number in date form

  • Ctrl + Shift + % Format number in percentage form

  • Ctrl + Shift + ^ Format number in scientific form

  • Ctrl + Shift + @ Format number in time form

  • Ctrl + W Close a workbook

  • Ctrl + O Open a workbook

  • Alt + H Go to the Home tab

  • Ctrl + S Save a workbook

  • Ctrl + C Copy selection

  • Ctrl + V Paste selection

  • Ctrl + O Open a workbook

  • Alt + H Go to the Home tab

  • Ctrl + S Save a workbook

  • Ctrl + C Copy selection

  • Ctrl + V Paste selection

  • Ctrl + Z Undo recent selection

  • Delete remove cell contents

  • Choose a fill colour Alt + H, H

  • Cut selection Ctrl + X

  • Go to the Insert tab Alt+N

  • Apply bold formatting Ctrl+Bb

  • Center align cell contents Alt+H, A, C

  • Go to the Page Layout tab

  • Go to the Data tab Alt+A

  • Go to the View tab Alt+W

  • Open the context menu Shift+F10 or Windows menu key

  • Add borders Alt+H, B

  • Delete column Alt+H, D, C

  • Go to the Formula tab Alt+M

  • Hide the selected rows Ctrl+9

  • Hide the selected columns Ctrl+0


Cheers,


The Table Originals team



bottom of page