If you don't like the standard font that is used by Excel  and you want your default style of you r Excel workbooks to always be your choice then it's really easy to do. <Excel...

I have recently been asked if it's possible to have a data validation list on another sheet.  Well, of course it is.  This is particularly useful if there is a danger of your list being overwritten...

I had a question form one of my colleagues about this. They have a validation list of products which has been used using for some time, with no new products being added. Then today- they are...

Ever inherited a monster of a spreadsheet?- silly questions we all have!, and more often than not one of the little issues with it is..those blasted blank cells.. that interrupt any data analysis we...

The Right function on Excel let's you extract a the last characters, or character in a text string based and it's based on the number of characters you specify you want to extract. This a a really...

This really is a time saver and well impresses colleagues if you needs to change around the look of an Excel sheet right in fromt of someones eyes! You might want to change around the layout of...