I have a spreadsheet that already has "drop down" arrows on every cell in a
column data to select from. I was able to find the data that is supposed to
be used for the "drop down" menu and that the data name range assigned to it.


The problem I'm having is that when I go to the menu bar and select Data,
the Validation option is greyed out.

How can access the data validation menu when it is greyed out? The entire
file is unprotected.

Thank you for your help!

Tom