check range of data validation

[needhelp2]

Hi dear all Again,


I needs to know is there any way through we can check range of data validation of respective row?
like to view range of cell "c3" i have to press ALT+A+VV, then it show me range.

is there any other way to check it easily.
e.g i enter formula in c5 and show me range of c3 cell

Thanks

 

[Trevor G]

Im not completely understanding your question, but have you tried this:

Are all the ranges named? if so you can always look at the Name box to check a name.

If you want to use a named range in a formula like AutoSum you can select a cell, then create the Sum (Like Alt + = on the keyboard) then you can use F3 (Function key F3) to list the names and select a name for the formula.

 

[needhelp2]

no buddy its not working.
Infect i want to view which value is assigned in validation.
i am using drop down menu.

 

[Trevor G]

If you are seeing a validation list from the drop down then you see the list?

Can you explain further what you are after?