If you have several empty rows in an Excel worksheet, it is a bit of a nuisance to go through and delete them all manually. You can select blanks cells, using… 132 more words
Tags » Microsoft Excel 2010
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. 102 more words
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… 62 more words
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… 100 more words
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. 174 more words
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. 54 more words
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. 109 more words