Home |
Search |
Today's Posts |
#1
|
|||
|
|||
List (Drop Down Menu) Scroll Bar
Hello,
In Excel, I am having problems with the drop down list, where it does not display the vertical scroll bar in an 800x600 pixels screen resolution, but it does on a 1024x768 pixels screen resolution and only when the zoom is a 125%. So I am unable to scroll down the list on an 800x600 pixels resolution, any help is much appreciated. Ideally, would like the scroll bar to show from the end of the cell border as opposed to show the scroll beyond other cells. Thank-you, -- Hans Emilio |
#2
|
|||
|
|||
If I recall correctly, there is an issue with drop-downs and freezing panes.
What happens if you unfreeze panes? I could be wrong... ************ Anne Troy www.OfficeArticles.com "Hans Emilio" wrote in message ... Hello, In Excel, I am having problems with the drop down list, where it does not display the vertical scroll bar in an 800x600 pixels screen resolution, but it does on a 1024x768 pixels screen resolution and only when the zoom is a 125%. So I am unable to scroll down the list on an 800x600 pixels resolution, any help is much appreciated. Ideally, would like the scroll bar to show from the end of the cell border as opposed to show the scroll beyond other cells. Thank-you, -- Hans Emilio |
#3
|
|||
|
|||
Thanks, but I do not have any freezing panes, and I tried with freezing panes
too. I have other drop down lists, and the drop down menu vertical scroll bar is right at the end of the cell, except for this particular drop down list menu, where the scroll bar goes beyond to other cells. All my drop down lists refer to a list of items in another sheet ..... thanks for your suggestion ... Hans -- Hans Emilio "Anne Troy" wrote: If I recall correctly, there is an issue with drop-downs and freezing panes. What happens if you unfreeze panes? I could be wrong... ************ Anne Troy www.OfficeArticles.com "Hans Emilio" wrote in message ... Hello, In Excel, I am having problems with the drop down list, where it does not display the vertical scroll bar in an 800x600 pixels screen resolution, but it does on a 1024x768 pixels screen resolution and only when the zoom is a 125%. So I am unable to scroll down the list on an 800x600 pixels resolution, any help is much appreciated. Ideally, would like the scroll bar to show from the end of the cell border as opposed to show the scroll beyond other cells. Thank-you, -- Hans Emilio |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with drop down menu | Excel Worksheet Functions | |||
Drop down list with an if statement | Excel Worksheet Functions | |||
Using symbols for drop down list boxes? | Excel Worksheet Functions | |||
drop down list creation | Excel Discussion (Misc queries) | |||
How do I set up a drop down menu within a drop down menu? | Excel Discussion (Misc queries) |