From Excel 2007 onwards you can use the Table command to convert a data list or set into a formatted Excel Table. Once your data is converted into a table you can use their many features such a...

Excel allows you to sort your data in many ways, but with Excel 2007 onwards we can now sort easily by the font colour or by the cell fill colour.  It is easy and effective and is available as a...

Do you ever get reams of paper printing at the end of your worksheet?   I have been asked about this a few times, even if users have deleted their empty rows that they no longer use, when they hit...

We all love a bit of formatting, but copying and/or repeating formatting can be a big pain unless you use the super format painter.  So, here is how to quickly copy formatting from one worksheet to...

If you have ever used data from Yahoo or Google in a data table have you retyped it in, or tried to copy and paste it? It either takes too long or the formatting appears all over the place.  Google...

I know someone who loves cell borders, they really do. I'm no fan myself in most circumstances.  But, in keeping with the Bronze Silver and Gold theme of the recently finished Olympics In London...