Monthly Archives: February 2014

Microsoft Excel – removing comma separators from numbers

Usually when working with large numbers it is useful to see the comma separator to be able to more clearly read the numbers. I was recently asked how to get rid of the commas. If you want to remove the … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , | 15 Comments

Microsoft Excel – creating a checkbox for several cells in a column

I was recently asked how to create a checkbox which could be copied and pasted into a range of cells in Excel. To work with checkboxes, you first have to have the Developer tab showing on the ribbon. To do … Continue reading

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

Microsoft Excel – entering last day of each month

When demonstrating the fill handle for series recently, I was asked whether Excel could work out the last date of each month. The answer is yes it can. If you enter the last dates of the first two months in … 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 Project – showing less labels in the legend when printing a Gantt Chart

When you print off a Gantt Chart, there are a lot of labels included in the legend which means that it takes up a lot of space at the bottom of the printout. If you are not using all the … Continue reading

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

Electronic business cards in Outlook 2010

When you create a contact you now also create an Electronic Business Card (EBC), which can be customised and shared with others or used as part of your signature. In Contacts view, the first option in the Navigation Pane is … Continue reading

Posted in Microsoft Outlook | Tagged , | Leave a comment

Creating a Photo Album in Microsoft PowerPoint

If you have a series of photographs, you can now create a presentation in the style of a photo album. You can then apply effects to your photos as outlined in the previous sections. To create a photo album:  Click … Continue reading

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

Microsoft Word – how can I edit my AutoText entries

If you have set up an AutoText entry and then your details change, you need to know how to edit the entry. To edit an AutoText entry in Word 2007 or Word 2010: Insert the Autotext entry into your document. … Continue reading

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

Microsoft Excel – copying conditional formatting to other cells

If you have created conditional formatting in one cell, you can copy that formatting to other cells using the Format Painter. Click in the cell containing the conditional formatting, then on the Home tab, in the Clipboard group, click Format … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , , , | 1 Comment

Microsoft Word – setting the starting page number

Microsoft Word automatically starts numbering pages at page 1, but you can start page numbering at a different number. You may also want to reset your page numbers if your document contains a cover page or if you need a … Continue reading

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