Validation above the Freeze Line

G

Guest

Hi All......

I have a cell to which I have appied Data Validation with a drop down box.
The cell is located above the Window Freeze Line on my sheet. Although the
"data Validation" part seems to work ok, the drop down arrow and window do
not appear, unless I delete the Freeze Line. This is my first observance of
this situation. Is it ordinary?.....Might I have some setting wrong?.....is
there a workaround?

Vaya con Dios,
Chuck, CABGx3
 
G

Guest

Thanks Peo.......

Indeed, that's what this machine has on it.......maybe a good enough reason
for an upgrade<g>

Vaya con Dios,
Chuck, CABGx3
 
D

Debra Dalgleish

Hi Chuck,

Instead of a Freeze line, you could split the window, and the dropdown
should work.

Debra
 
G

Guest

Thanks Debra,
I never thought of that......I'll give it a try.

Vaya con Dios,
Chuck, CABGx3
 

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

Similar Threads

Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Freeze Panes , Data Validation Conflict 2
Data validation and Freeze Panes 2
Data Validation Error 1
Validation....divisible by 8 only 5
Validation box formula 4
Data validation list using filtered range 3
Data validation only works once 1

Top