Drop down menu is being cut off?

[macleod92]

Hello all,

Thanks in advance for the help.

So I’ve created a range of cells which contain drop down menus based off of a list created using Data Validation.

The drop down menus work and contain the information from my list. While at the top of the spreadsheet the drop down menus show every item, however the more I scroll down the less of the list I can see. I can’t scroll within the list to move around it, I’m stuck with what I can see.
I’ve included two screenshots which show how much of the drop down menu I can see at the top of the spreadsheet versus the bottom, hopefully this sufficiently illustrates the problem.

Screenshot #1 (Top of spreadsheet) https://drive.google.com/open?id=0B_UH1Uv2rYdMQjBFUUpiRTBvbWs

Screenshot #2 (Bottom of spreadsheet) https://drive.google.com/open?id=0B_UH1Uv2rYdMU0FudjlXVG95RDQ


Any help with this would be greatly appreciated as it makes the entire spreadsheet a bit useless without the ability to use the drop down menu.


Cheers,

Jamie

 

[mole999]

any frozen cells intersecting with your list

 

[macleod92]

No there shouldn't be.

 

[macleod92]

I just tried recreating it on a Windows computer at work and there is no issue. However, if I open the file created on a Mac on the Windows computer the problem remains.