Drop Down menu's

L

Lee

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
 
A

Allllen

probably a shared workbook.

to make your changes, go to tools>share>workbook
double check you are the only one with it open
then uncheck the box "allow changes by more than one user at the same time"
it will resave
now you can make your changes

then you can go back and turn sharing on again (check the box) if you want
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top