I have created a s'sheet which has drop down menu's under each of the
headings to make it easier to collate information at the end of the week.

Now that colleagues have started adding info onto the sheet it won't let me
add more catogaries to my drop down menu's.

When i click on 'DATA' the 'Validation' option is 'greyed out'

anyone help?

Lee