Tags » Microsoft Excel 2010

Microsoft Excel – I’ve hidden column A – how can I get it back?

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

Microsoft Excel

Microsoft Excel – Number of times delegates have attended conference

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

Microsoft Excel

Microsoft Excel - deleting all blank 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