Monthly Archives: February 2022

Microsoft Excel – removing completely blank rows

I was training at client site recently. One lady was receiving data imported into Excel and sometimes the text spilt over into two rows. She needed to keep both rows but cells on either side might be blank and there … Continue reading

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

Microsoft Excel – Autofill options icon not displaying

I was training Excel recently and we were copying down a formula to cells where the final cell to be copied to had a bottom border. When we copy a formula using the fill handle, Excel copies the formatting as … Continue reading

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

Microsoft Excel – XLOOKUP using multiple criteria across worksheets

I was at a client site recently and they had information across two worksheets. There was not one column that would provide a unique identifier to use in an XLOOKUP but a combination of two columns would provide a unique … Continue reading

Posted in Excel 365, Microsoft Excel, Microsoft Excel 2016 | Tagged , , , | Leave a comment

Microsoft Project – showing Timeline within a specific date range

In Microsoft Project, you may well have added tasks to the Timeline, but then want to narrow it down so that you can just see a specific date range. If you are clicked on one of the bars in the … Continue reading

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