Tip of the week # 591
12 December 2019

Best of 2019 - top 10 tips *

This will be the last tip of the year as I'm pretty sure that if I leave it another week I will get lots and lots of "out of office" messages stating you're tucking into mince pies and drinking mulled wine.

For the fifth year running, herewith your favourite, most commented on, tips from the past 12 months. As I felt it was impossible to cut it down to ten, I cheated and added three more. With thanks to Sarah, Bart, Jan, Patrick, Clare and Michael for your feedback; it makes my day knowing I'm saving you time and frustration!

  1. Open the right-click menu using a keyboard shortcut - Office and Windows - tip_560.php
  2. Total the data in a table - Excel - tip_561.php
  3. Answer and write prefixed comments below the original message text - Outlook - tip_563.php
  4. Fill all selected cells with the same text, number or formula - Excel - tip_562.php
  5. Find all occurrences of two spaces after a full stop and replace them with one - Word - tip_565.php
  6. Show totals above a table column that match specific criteria - Excel - tip_572.php
  7. Check the spelling of all worksheets - Excel - tip_573.php
  8. Attach a PDF version of an active document to an email message - Word, PowerPoint, Excel - tip_574.php
  9. Reduce the number of messages in your inbox upon your return from holiday - Outlook - tip_576.php
  10. Go to a specific slide when delivering your presentation - PowerPoint - tip_568.php
  11. Organise and find email messages in your shared mailbox - Outlook - tip_580.php
  12. Warn before printing, saving or sending a file that contains tracked changes or comments - Word - tip_584.php
  13. Quickly spot whether change tracking is on or off - Word - tip_586.php

Oh, and don't forget to check out tip_489.php before you're off on your Christmas break; it contains 5 tips to prevent email overload upon your return.

Wishing you a relaxing festive season. Remember: Escape isn't just a button on your keyboard!

Related tips

  1. Best of 2018 - top 10 tips - tip_559.php
  2. Best of 2017 - top 10 tips - tip_529.php
  3. Best of 2016 - top 10 tips - tip_502.php
  4. Best of 2015 - top 10 tips - tip_470.php


* Unless stated otherwise, these tips were written for Microsoft Office 2010.