Monthly Archives: November 2013

Microsoft Excel – shortcut keys for current date and time – non-changing

If you want to put the current date and time into an Excel workbook, but you don’t want them to update: For today’s date, press Ctrl + ; For the current time, use Ctrl + Shift + : Find out … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , , , | Leave a comment

Microsoft Excel – same print settings for several worksheets

I was asked whether there is a quick way to change print settings for several worksheets at once. The answer is to group the worksheets for which you want similar settings. If the worksheets are next to each other in … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , | Leave a comment

Microsoft Outlook – all day event issues

The quickest way to create an all day event in the Microsoft Outlook calendar is to double-click in the space towards the top of the calendar. This opens up the Events dialog box. However if you look in the Options … Continue reading

Posted in Microsoft Outlook, Microsoft Outlook 2007, Microsoft Outlook 2010, Microsoft Outlook 2013, Microsoft Outlook 2016 | Tagged , | Leave a comment

Microsoft Word – I cannot see Heading 3 in my Quick Style Gallery – how can I locate it?

When teaching Styles in Microsoft Word recently, we were doing an exercise to use Heading 1, Heading 2 and Heading 3 styles. However, on some of the training computers, Heading 3 was not visible on the Styles Gallery in the … Continue reading

Posted in Microsoft Word, Microsoft Word 2007, Microsoft Word 2010, Microsoft Word 2013, Microsoft Word 2016 | Tagged , , | 2 Comments

Finding Microsoft Outlook 2007 e-mails received within a certain time frame

It may be that you want to find all e-mails received within a particular time frame, say any e-mail message that was received over two years ago. If you are using Outlook 2007: Click Tools – Instant Search – Advanced … Continue reading

Posted in Microsoft Outlook | Tagged , | Leave a comment

Microsoft Outlook contacts – stored as First name, last name when needed as Last name, First name

When adding names to Outlook contacts, you may inadvertently have added some so that they are stored as First name followed by Last name, and others as Last name followed by First name. If you want to view the contacts, … Continue reading

Posted in Microsoft Outlook, Microsoft Outlook 2007, Microsoft Outlook 2010, Microsoft Outlook 2013, Microsoft Outlook 2016 | Tagged , , , | Leave a comment

Microsoft PowerPoint – embedding a YouTube video into PowerPoint

If you have PowerPoint 2010 or PowerPoint 2013, you can embed a YouTube video into your presentation. Please note that requirements for online video sites (Youtube, etc.)  using PowerPoint 2010 are as follows: Flash Player 10+ Windows Media Player 10 or … Continue reading

Posted in Microsoft PowerPoint, Microsoft PowerPoint 2010, Microsoft PowerPoint 2013 | Tagged , , | Leave a comment

Microsoft Word – Page number on footer issues

When working with headers and footers in Microsoft Word 2007, Microsoft Word 2010, Microsoft Word 2013 or Microsoft Word 2016, you have to be careful when adding a page number or you find that the rest of the header or … Continue reading

Posted in Microsoft Word, Microsoft Word 2007, Microsoft Word 2010, Microsoft Word 2013, Microsoft Word 2016 | Tagged , , | Leave a comment