Drop down list & frozen panes

N

naive14

I have a worksheet with column C containing a drop down list in each cell
using the Data...Validation feature.

Normally when the cell is selected a down-arrow icon is shown to the right
of the cell and I am able to choose between list elements.

The problem is that I have frozen a pane between column C & D such that when
you scroll to the right, column D slips to the left underneath column C. The
down-arrow icon disappears and I am not able to choose from the list anymore.

Any ideas how to prevent this ?
 
P

pinmaster

Hi,

An alternative to the arrow is to use the Alt+Down Arrow to bring up the list.

HTH
Jean-Guy
 
G

Gord Dibben

Either move the freeze line somewhere else or select the DV cell in C and Alt +
DownArrow to open the list.

Then select value with DownArrow


Gord Dibben MS Excel MVP
 
N

naive14

Yes, that works fine. Thank you both.


Gord Dibben said:
Either move the freeze line somewhere else or select the DV cell in C and Alt +
DownArrow to open the list.

Then select value with DownArrow


Gord Dibben MS Excel MVP
Click to expand...
 

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

Drop down list control value in vba 2
Drop down lists in seperate columns 5
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Filtered drop down list 2
Move Drop Down List to the Top of the Cell 0
move to adjacent cell with panes frozen 1
Size of drop down in validation list 3
Print Macro w/drop down list 1

Top