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...
Recent Posts
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...
In Excel you aren't restricted to having your whole cell full of text formatted in the same way. You can have individual formatting on different characters within a cell. (This only...