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.


Julie Hickson | 1 December 2015

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 Excel keyboard shortcuts you should know, helping you navigate Excel more quickly and saving you time.

  1. Control+Down/Up Arrow

    Moves to the top or bottom cell of the current column.

  2. Control+Left/Right Arrow

    Moves the cell furthest left or right in the current row.

  3. Control+Shift+Down/Up Arrow

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

  4. Control+Shift+Left/Right Arrow

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

  5. Control+Shift+8 or Control+*

    Selects all cells in a range

  6. Shift+F11

    Creates a new blank worksheet within your workbook.

  7. F2+=

    Opens the cell for editing in the formula bar.

  8. Control+Home

    Navigates to cell A1

  9. Control+End

    Navigates to the last cell which has been used.

  10. Alt+=

    Autosums the cells above the current cell

  11. Control+Shift+=

    Insert a row or column

  12. Control+-

    Delete a row or column

  13. Control+;

    Insert the current date


More information

As Microsoft's 2015 Worldwide Learning Partner of the Year, we deliver quality training. We offer a wide range of Microsoft Excel training courses, from introduction to advanced, helping you make the most of this powerful tool.

 

 

QA Training | Julie Hickson

Julie Hickson

Senior Office Applications Specialist

Julie is a MOS Master instructor based in the North-West, and has been training for over 15 years; she joined QA in 2012 working as a Business Applications Specialist. Julie is passionate about training and specialising in Excel, Microsoft Project and PowerPoint. Julie has extensive experience of delivering training to all levels, in a variety of formats, including virtual.
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.