Validation Dropdown list is not available

M

Makelei

Hi,
I have entered this today earlier, but it has not been visible in the forum,
so, please, bare with me if it is already there...

I have XP and 2003.
Here's my problem: I have defined to one column validation. As I select one
of the cells, the dropdown list does not come available as usually. I have
had once before the same problem, but I cannot remember how it can be
resolved.

I have tried to make correction with another file. Creating column with
needed validation and it works perfectly. As I copy the column to original
file - again same problem - validation dropdown list (the arrow) is not
visible. But as I click the secondary mouse button I am able to select "Pick
From DropDown List..."

If I recall correctly, there is some kind of list function that needs to be
replaced, but cannot remember how...

Thanks in advance
Makelei
 
G

Gord Dibben

Answered at your other posting but maybe you don't see that.

Tools>Options>View>Objects "Show All"


Gord Dibben MS Excel MVP
 

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