15 time-saving tips and shortcuts in Word, Excel and Outlook

The only thing we all can agree on is that we do not have enough time to achieve everything. The best way to find that missing time is to save time. Improving your skills in common software tools such as Excel, Word and Outlook can be a great way to start saving a few minutes here and there. Because these software tools are most commonly used on a daily basis, we have decided to give you a list of 15 useful tips and shortcuts that will save you time.

 

 Word

 

  1. CTRL + Enter

You would be amazed to know how many people still use manual page break by pressing Enter key repeatedly. Use this shortcut to make your life easier. Use this to insert an automatic page break.

 

  1. Shift + F5

Use this shortcut to automatically return to the last edit point.

 

  1. Shift + F3

This shortcut will allow you tho change the case of selected text. No more deleting and rewriting!

 

  1. F4

Pressing F4 will repeat your last command which is very useful when you have to do some action repeatedly.

 

  1. Double click and triple click

Double click on a word and you will select only that word. If you triple click, you will select the paragraph. Use CTRL + click to select a single sentence.

 

 

 Excel

 

  1. Automatic SUM () with ALT + =

This will automatically sum all the cells above and display the sum in the current cell.

 

  1. CTRL +

Use this shortcut to display Formulas to easily identify and fix an issue with them.

 

  1. Easy jumping to the Start and End of a column

If you have thousands of rows of data, you can scroll but if you want to do it easily, use CTRL + Arrow Up and Arrow Down keys to go in the wanted direction.

 

  1. Switch between sheets

Use CTRL + PGDN or CTRL + PGUP to easily navigate through multiple worksheets.

 

  1. Double-click Format Painter

Double click on Format Painter in order to apply the format to multiple cells.

 

 

 Outlook

 

  1. Get back your To-Do bar

To-Do bar is automatically disabled in Outlook 2013. Return it by clicking View tab, selecting To-Do bar and select which items will appear on your To-Do bar from the dropdown list.

 

  1. Chose the way how you see your inbox

If you are not happy with how Outlook displays your message list, change it. Simply click the View tab on the ribbon toolbar and choose Change View. Here, you can also turn off Message Preview if you want.

 

  1. Connect Outlook to your social networks

If you want to link Outlook to your social network, go to File, Info, Account Settings, Social Network accounts.

 

  1. Use the Favourites

Your Outlook can easily get crowded if you have multiple accounts. Add accounts that you use the most as Favourites so you can get to them more quickly by going to View, Folder Pane and clicking on Favourites to enable them.

 

  1. Clean up your contacts

If you connect your social networks to your Outlook, you can end up with having multiple contact entries for a single person. In order to merge duplicate contacts, click on Home and then People. Click Link Contacts and follow the screen to perform easy merge of duplicate contacts.

 

Sign Up

Myriam Balerio is the founder and writer of PA Privé. After kick starting her career as a PA and finding success as an assistant, Myriam later trained in digital and online marketing and has since combined the two disciplines in creating PA Privé, the platform through which she provides sage advice for those in the assistant profession and a network for like-mined PAs and EAs to connect. Born in Buenos Aires, Argentina, Myriam has lived in London for over 10 years and currently lives in London with her husband and French bulldog.

mbalerio

Comments are closed.