Essential Microsoft Office shortcuts


Speed up your productivity by using shortcuts. Microsoft Office provides us with a huge number of shortcuts that we can choose to use but there is little point in trying to remember all of them.  Instead choose to find out about the shortcuts that will be most helpful to you.  The following are shortcuts that are a must in all Office applications.

 

Copy, move and paste

Select the data you want to move or copy using the appropriate shortcut below and paste it into the new area of your spreadsheet or to another spreadsheet, workbook or even to another application.

Hold the Ctrl key and the letter c key     –   this copies your selected text to the clipboard

Hold the Ctrl key and the letter v key     –   this pastes your copied text to the new position

Hold the Ctrl key and the letter x key     –   this cuts your selected text ready for you to move it by pasting it to the new position

 

Home and End

The Home and End keys are located either at the top of your number pad or to the right hand side of your keyboard.  They can be used on their own to move your cursor to the beginning or the end of the row you are on or along with the Control key to move you to the beginning or end of your spreadsheet.

Hold the Ctrl key and the home key   …….   this takes you to the beginning of your spreadsheet

Hold the Ctrl key and the end key   ………..  this takes you to the end of your spreadsheet

Click the end key      ………………………………. this takes you to the end of the row

Click the home key         …………………………. this takes you to the beginning of the row

 

Formatting shortcuts

Hold the Ctrl key and the letter b key   –   this applies or removes bold formatting to selected text

Hold the Ctrl key and the letter i key   –    this applies or removes italics formatting to selected text

Hold the Ctrl key and the letter u key   –   this applies or removes underline formatting to selected text

 

Undo and Repeat

Hold the Ctrl key and the letter z key   …..   this will undo your last action

Hold the Ctrl key and the letter y key    ….   this will repeat your last action

 

Open, Print and Save

Hold the Ctrl key and the letter o key   –    this will display the open dialogue box to open a file

Hold the Ctrl key and the letter p key    –   this will display the print area

Hold the Ctrl key and the letter s key     –   this will save the active file

 

Select All

Hold the Ctrl key and the letter a key     –   this will select everything in your worksheet

 

If you would like to know more about Office applications why not give F1plus a call on 01224 619780 or browse through our website at www.f1plus.co.uk and come and try one of our courses.