When you are working with Excel, you sometimes hide rows or columns but may well want to unhide them again. As long as it is not column A or Row 1 you have hidden – it is very easy – just select the columns or rows on either side of the hidden ones, right-click, then click… 66 more words
Tags » Microsoft Excel 2010
I have a client that organises an annual conference for its members. Each member has a unique Membership ID. Each conference delegate list is on a separate worksheet. 133 more words
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
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