Top 10 benefits of online learning courses

Essential Microsoft Excel Shortcuts

In this article we list some of the top Microsoft Excel shortcuts you should know, helping you navigate Excel more easily.


QA | 28 March 2017

Microsoft excel

Essential Excel Keyboard Shortcuts You Must Know

Keyboard shortcuts can really improve your productivity for frequent users of Microsoft Excel. This article runs through some of the top  keyboard shortcuts you should know.

And to help you navigate Excel more quickly, print out our handy cheat sheet so you can have these essential shortcuts to hand.

 

Navigating a workbook

 

  1. Move to the top or bottom cell of current column

  2. Control + Down/Up Arrow (moves to the next non blank cell in column)

  3. Navigate across worksheets

  4. Control + Page Up/Page Down

  5. Move to the next non blank cell in a row

  6. Control  + Left/Right Arrow

  7. Selects all cells containing data above or below the current cell

  8. Control + Shift + Down/Up Arrow

  9. Select all cells containing data to the left or right of the current cell 

  10. Control + Shift + Left/Right Arrow

  11. Select all cells in a range

  12. Control + Shift +

  13. Create a new blank worksheet within workbook

  14. Shift + F11

  15. Open the cell for editing in the formula bar

  16. F2 

  17. Navigates to cell A1 (or top left of sheet if Freeze panes is on)

  18. Control + Home

  19. Navigate to the last cell which has been used

  20. Control + End

  21. Autosum the numbers above the current cell (or numbers to the left of the current cell)

  22. Alt + =

  23. Insert row or column

  24. Control + Shift + =

  25. Delete row or column

  26. Control +  -

  27. Add or remove filters

  28. Control + Shift + L

 

Formatting

 

  1. Insert the current date

  2. Control + ;

  3. Display the format cells dialog box

  4. Control + 1

  5. Apply number formatting

  6. Control + Shift + 1

  7. Apply currency formatting

  8. Control + Shift + 4

  9. Apply percentage formatting

  10. Control + Shift + 5

 

Grouping worksheets

 

  1. Make same change to multiple worksheets

  2. Click first required sheet and then Shift + Click the last required sheet

 

Want to learn more about Excel? Our Introductory Excel training courses are designed for beginners who want to learn how to create, edit, format and print basic worksheets. Advanced Excel training courses will enable you to apply advanced analysis techniques to more complex data sets such as PivotTables. 

Related blogs and videos

Video tutorials: Freeze panes, transpose and autofill in Excel

Video tutorials: VLOOKUP in Excel

Video tutorials: Creating a Pivot Table in Excel

Video tutorials: Conditional Formatting in Excel

Microsoft PowerPoint video tutorials

How to avoid death by PowerPoint


Talk to our learning experts

Talk to our team of learning experts

Every business has different learning needs. QA has over 30 years of experience in combining the highest quality training with the most comprehensive range of learning services, ensuring the very best fit for your organisation.

Get in touch with our learning experts to talk about how we can help.