Get rid of those leading spaces and apostrophes Have you ever imported data into Excel and discovered lots of leading spaces? Or leading Apostrophes? I know I have. This is not very useful as a leading spaces do not allow for effective sorting. Here is how the Trim function can help to remove them. In […]
The Format Painter is a great tool for copying formatting from one part of a document to another. So if you have spent ages working out just how you want a heading to look, and then realise you want to copy the formatting to another part of your document, the Format Painter will do this […]
Count or Sum the entries if your criteria are met – Excel 2007,2010 and 2013 Here is a list of the CDs in a collection and their cost: =SumIF The SUMIF function adds up a list of figures based on the criteria that you set. In my example above I want to add up the […]
The Auto fill feature will save you lots of time when copying formulae across a whole row or when filling a list. To do this place your cursor over the little black box in the bottom right hand corner of the cell you wish to copy and drag it across to the other cells. The […]
You can also get Excel to pick the Minimum or smallest number from your list or the Maximum – the largest number in your list. Simply select the appropriate function from the Auto Sum drop down menu.
Create a Summary Sheet in Excel 2007 and Excel 2010 You have a workbook with several worksheets for different months and you now need one worksheet that summarises all of the others. First set up the summary sheet how you want it to look. To copy the contents of a single cell from one work […]