Monthly Archives: February 2015

Microsoft Project – moving completed parts of tasks back to Status date

Sometimes on a project, some tasks actually get started ahead of schedule! In that case when we are tracking, we may want to move the bits that are done back to the Status date, so that subsequent tasks can get … Continue reading

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

Microsoft Excel – showing field names as headings rather than “Row labels” in Pivot tables

In Microsoft Excel 2007 and 2010, by default if you create a pivot table, instead of showing the field names, it will say row labels and column labels. Show in Outline Form or Show in Tabular form. The relevant labels … Continue reading

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

Microsoft Outlook – Sharing Contact Groups

If you have gone to the effort of creating an Outlook contact group, you may want others to be able to use it too. To share your Outlook contact group, from within Outlook, click Contacts, then click on the Contact … Continue reading

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

Microsoft Outlook – stopping messages showing as read as soon as you click on them

I was asked whether it was possible to stop messages showing as having been read as soon as you click on them. To do so, go to View – Reading Pane – Options. Remove the tick from the Mark items … Continue reading

Posted in Microsoft Outlook 2010 | Tagged , | Leave a comment

Microsoft Excel 2013 – saving a workbook as a template

In earlier versions of Microsoft Excel, workbooks saved as templates where automatically saved into a Microsoft Templates folder. In Excel 2013, if you want to be able to save templates so that they become personal templates, you first need to … Continue reading

Posted in Microsoft Excel 2013 | Tagged , | Leave a comment

Crystal Reports – change ‘$0.00’ to ‘-‘

To change the $0.00 to $- , right-click the relevant field and select Format – Field. On the Number tab, click Customize. On the Number tab, in the Show Zero Values as dropdown, select the dash ‘-‘. Then go to … Continue reading

Posted in Crystal Reports | Tagged , | Leave a comment

Crystal Reports – formatting zeros as blanks

If you have zeros in a report, you may want to show them as blanks. Right-click on the relevant field and select Format Field from the shortcut menu that appears. On the Number tab, click Customize. On the Number tab, … Continue reading

Posted in Crystal Reports | Tagged , | Leave a comment

Crystal Reports – Mailing Labels – changing label size once labels have been created

When you have created labels using the Mailing Label Report Wizard, what happens if you then want to use a different label size with the same generated names? There is no Mailing Label Expert and you cannot get back into … Continue reading

Posted in Crystal Reports | Tagged , | Leave a comment

Using Option Buttons in Word forms

If you are creating Word forms using the Developer ribbon, it is very straightforward to create checkboxes for respondents to select choices. However, they can select as many checkboxes as they like. Sometimes you may only want them to make … Continue reading

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

Microsoft Word – grouping shapes and pictures together

If you insert a shape and a picture into a Word document, you may want to group them together for the purpose, for example, of copying and pasting. If you try to group them together having just inserted them, you … Continue reading

Posted in Microsoft Word, Microsoft Word 2007, Microsoft Word 2010 | Tagged | 1 Comment