Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Hans Emilio
 
Posts: n/a
Default 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   Report Post  
Anne Troy
 
Posts: n/a
Default

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   Report Post  
Hans Emilio
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with drop down menu Jrr6415sun Excel Worksheet Functions 4 July 10th 05 05:58 PM
Drop down list with an if statement khelton Excel Worksheet Functions 2 June 6th 05 09:11 PM
Using symbols for drop down list boxes? Sumeet Benawra Excel Worksheet Functions 0 April 19th 05 11:41 AM
drop down list creation swesa Excel Discussion (Misc queries) 1 April 16th 05 12:38 AM
How do I set up a drop down menu within a drop down menu? Rob Excel Discussion (Misc queries) 1 April 12th 05 06:02 PM


All times are GMT +1. The time now is 11:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"