So, you think you know some pretty nifty shortcuts in Excel?.  How's about this one, race you to draw borders around your cells...... Ok, so have you taken your hands off the keyboard, grab your...

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...