Monthly Archives: September 2016

Microsoft Excel – Formatting of Subtotals

Originally posted on ifonlyidknownthat:
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…

Posted in Uncategorized | Leave a comment

Fill without formatting in MS Excel

Originally posted on ifonlyidknownthat:
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…

Posted in Uncategorized | Leave a comment

Microsoft Excel – display a dash (-) instead of a zero

Originally posted on ifonlyidknownthat:
I was asked by a client how I could display a dash (-) instead of 0 in cells. Although this could be done by the use of an IF statement, an easier way to do it…

Posted in Uncategorized | Leave a comment

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

Originally posted on ifonlyidknownthat:
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…

Posted in Uncategorized | Leave a comment