Highlight or performing selection is the first action you’ll take before making any changes to the selected items. Down Arrow : Move one letter or cell down.

Right Arrow : Move one letter or cell to the right.Left Arrow : Move one letter or cell to the left.Ctrl + (Right arrow) : Move one word to the right at a time.

Ctrl + (Left arrow) : Move one word to the left at a time.

Ctrl + End : Go to the end of a document.

Ctrl + Home : Go to the beginning of the document.

End : Go to the end of the current line.

Home : Takes the user to the beginning of the current line.

Shortcut keys that can help to get from point “A” to point “B” without the use of your mouse can be very useful for laptop users.

Alt + E : Edits options in the current program.Ĭorrecting any mistakes you’ve made on the fly, these shortcut keys can save you a lot of time.

Alt + F : File menu options in the current program.

F1 : Universal help (for any sort of program).

Quickly finding help and changing your setting without a mouse is the difference between a beginner and an expert user.

Ctrl + F : Find and replace the dialog box.

Here is the list in a format you can print or clip.Simple but powerful common Microsoft office shortcut keys that can be used across all applications designed by Microsoft. Which are your favourite time-saving Excel shortcuts? Which ones should be on this list?

It is worth spending a little time to learn the shortcuts on this page, they are the ones people ask me about the most, and to continue discovering more of your own. Shortcuts are a great way to minimise the amount of clicking and selecting that you would have to do when working with large spreadsheets. There are many ways to accomplish the same tasks in an Excel spreadsheet. You can usually locate the key just above the key – it’s not the same as that you use all the time. + to show formulas and again to hide formulas. This command is found in the Formula Auditing Group of the Formulas tab in Excel. Speaking of SUM and formulas in general, few people know that they can do this at all but it’s essential when you need to troubleshoot or audit an existing spreadsheet, when you want a bird’s eye view of how it’s built and check that formulas are consistent.

Windows excel shortcut keys