Tags » Microsoft Excel 2010

Microsoft Excel - deleting all rows in a worksheet

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

Microsoft Excel

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. 102 more words

Microsoft Excel

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… 62 more words

Microsoft Excel

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… 100 more words

Microsoft Excel

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. 174 more words

Microsoft Excel

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. 54 more words

Microsoft Excel

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. 109 more words

Microsoft Excel