Tag Archives: formatting

Microsoft Word – getting back to normal text after using text effects

If you use the Text Effects   button in the Font group on the Home tab, you produce some interesting effects. However, it is not then obvious how to get back to normal writing! To do so, click the Clear … Continue reading

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

Microsoft Project – colour coding by Resource Group

I was asked by a client recently as to whether she could colour code by Resource Group. First add column Resource Group to your view. You can always hide it again afterwards. You may also want to got to Gantt … Continue reading

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

Removing blanks from credit card entries in Microsoft Excel

I was asked recently how to get rid of blanks in credit card entries within an Excel worksheet, e.g 1000 2000 3000 4000 should read 1000200030004000. The way I did it was select all cells in the Credit card column, … Continue reading

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

Fill without formatting in MS Excel

When you use the AutoFill handle in Excel, as well as copying your formula it also copies your formatting. In the example shown here, the worksheet was already formatted with a border around the table. When you use the AutoFill … Continue reading

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

Microsoft Excel – Formatting of Subtotals

I was demonstrating subtotals to a client today and she wanted to know how to format all the subtotal rows in bold with a different background cell colour. The workbook we were using had Counts for the subtotal. In the … Continue reading

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