microsoft excel training courses london - EXCEL

Hi Jaz,

Validation in cells is where you will only allow a certain criteria of data to be input into a cell. You do this by highlighting where you want to put the validation in, then go into the Data menu and down to the option that says Validation then simply put in the options as to what you want to be input, there is also an option of editing the error message.

Have a look at that option and see what you think.

Tracy