Category Archives: Microsoft Excel 2010

Microsoft Excel – copying and pasting between two filtered workbooks

I was at client site yesterday and one learner said that they were having great difficulty copying and pasting information between two filtered workbooks. I said he should use Find and Select – Go To Special – Visible cells only … Continue reading

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

Microsoft PowerPoint – inserting several pictures all same size

When working with Microsoft PowerPoint, you may want several pictures on a slide to all be of the same size. Insert your first picture, then on the Picture Tools Format tab, in the Size group, select your required size, or … Continue reading

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

Microsoft Excel – keeping original column widths when pasting data

Sometimes you spend a lot of time and effort getting the columns on a worksheet to the exact widths that you want and then need to copy and paste the data elsewhere. The last thing you want is to then … Continue reading

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

Microsoft Excel – quickly unhide all columns or rows

If you have hidden multiple rows or columns in Excel, it can take a while to work out what you have hidden to unhide again. It is also hard to work out how to unhide column A or row 1! … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Leave a comment

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 – … Continue reading

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

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. The client wanted to know how they could work out how many … Continue reading

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

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 Go to Special, but if you are not careful … Continue reading

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

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.   If you really want to see the gridline, you … Continue reading

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

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 ESTATE in the description. Then, on the Data tab, I click the big Sort button … Continue reading

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

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 tab, in the Data group, click Select Data. At the left under Legend … Continue reading

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