Do you want your text always to be bold, or red or any other formatting automatically as you type. A great, quick way to do this is to set up Conditional Formatting that kicks in if the user enters...
Category: Excel Tips& Tricks
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...
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...