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.

How to get a complete list of Functions from Microsoft Help


The majority of functions can be found in the Formula tab by clicking on the drop down arrow of the category of function in the Function Library section…see pic below:

list-of-functions-pic-1

You can however also find a complete list in the Microsoft Help system by clicking on the question mark icon ( ? ) at the top right of your Excel screen.

This will connect you to Office.com where all the ‘Help’ support is located.

When the ‘Excel Help’ screen appears type ‘excel functions’ into the search box.

The following screen will then appear:

list-of-functions-pic-4

You can click on any of the links – the first will give you a categorised list and the one marked ‘Excel functions (alphabetical)’ will give you the full list in alphabetical order.

list-of-functions-pic-5

list-of-functions-pic-6

If you need any further help with Excel functions why not call F1plus on 01224 619780 or browse through our website at www.f1plus.co.uk to find out about our Excel courses.

How do I print the list of tasks for each of my Resources in Project?


How do I print the list of tasks for each of my Resources in Project?

Microsoft Project has a really good Reporting facility however sometimes all you need to get the information required is to simply arrange your screen so that you can see the information and then print it out.

We can do this by creating a combination view with the Resources at the top of the screen and the Tasks for these Resources at the bottom.  See pic below:

 

 

pic-from-Project-blog

To show the Resource Sheet at the top click on the View tab of the Ribbon and then click on Resource Sheet in the Resource Views section.

To make this a Combination View with the Tasks showing at the bottom – stay in the View tab and go to the Split View section and click on Details.  Click on the drop down showing to the right and choose Task Sheet if it is not already showing.  You now have the Combination that you need with the Resources at the top and the Tasks at the bottom.  However it may still not be showing the information that you need and you may therefore need to format the Task Sheet in order to see the detail required.

To format the Task Sheet first of all click on the lower half of your screen where the Task Sheet is showing and then go to the Data section of the View tab and click on the drop down for Tables and choose the detail that you need.  ie if you want to see the information regarding scheduling click on the Schedule table.

Now that you have the detail that you need showing on your screen you can print the Task list for each Resource by first of all clicking on the chosen Resource at the top section (Resource Sheet) and then clicking on the Task Sheet at the bottom and then File and then Print.  Only the task list for that particular resource will be showing in the preview….and now click Print.

More information on Printing specific views can be found in Chapter 14 of Project Module 1 – Printing and Reporting.

To find out more about Project or book the course please click here.

1 2