Sometimes it's necessary to limit the number of character entries into cells, for example account codes or user names.  You may want to limit an account code to 6 characters.  This cuts down on...

I received an Excel file today from one of my colleagues that contained carriage returns at the end of each line of text, these were displayed  as small boxes. They were having trouble splitting out...

Sometimes you really want to control what people type into Excel, especially if you need to do some analysis on the data at a later date, so all the input are uniform and easy to analyse. There are...