Author Archives: jdonbavand

About jdonbavand

I am a trainer of Microsoft Office, Microsoft Project and Crystal Reports. I have called my blog "If Only I'd Known That...." because I hear it so many times in training sessions. In fact, if only I had a £100 (or 150 Aussie dollars)for every time someone says "If only I'd known that." ....

Microsoft Excel – gridlines lost when formatting cell background

When you add colour to a cell background in Excel, either manually using the Cell Background   button or by using Conditional Formatting, you lose the gridline round the cell.   If you really want to see the gridline, you … Continue reading

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

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 Excel – Sorting by colour and within that alphabetically

If you conditionally format data in Excel, you can sort by colour.  In the above data set, I have conditionally formatted all those with word ESTATE in the description. Then, on the Data tab, I click the big Sort button … Continue reading

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

Microsoft Excel – using series from more than one worksheet in a chart

Sometimes you may create a chart in Excel and then want to add data from another worksheet. To add in extra data, on the Chart Tools Design tab, in the Data group, click Select Data. At the left under Legend … Continue reading

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

Microsoft Excel – date format of Monday 1 Jan 2018

I was asked whether I could create a date format of Monday 1 Jan 2018 and copy it down to Tuesday 2 Jan 2018 etc. This requires a custom format. However, I also found it required me changing my computer … Continue reading

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

Microsoft Excel – quick entry of last day of every month

To enter the last day of every month into a column in a worksheet, first enter the last date of the first month to be included, say 31/01/2017. Drag down to fill in as many as required. Go to the … 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 – adding an “X” or equivalent text in several cells in a column

I was asked recently how one could add X to every number in a cell – this would be for a product code, a part number etc. This is a matter of formatting the data. Select the cells you want … 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 – changing text size on Gantt Chart

If you have text on top of Gantt bars, it can sometimes take up a lot of space and make each row quite deep. To change the text size on the Gantt chart, on the Gantt Chart Tools Format tab, … Continue reading

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

Microsoft Excel – handling a mix of calendar days and business days

Someone I was training recently had been given a spreadsheet with dates from the beginning of the month – some as calendar dates – ending is st, nd, rd, th and some with no suffix which were business days from … Continue reading

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

Microsoft Excel – keep sort details when creating sorts on more than one set of data

A client had a tennis scoring spreadsheet with different sets of data for different divisions on the same worksheet. Players on equal points are thereafter ranked on best games difference, then games won and then head to head. Whenever he … Continue reading

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