Pulldown list opens out of view

**Jen is me** · 10-27-2008, 03:06 PM

I have created a test with pulldown lists for answer choices. All is fine until the file is opened on a computer with a smaller monitor or I can re-create it by reducing view to 75%. At that point when you click on the arrow for pull down... the box opens way to the left and you can't see the the first several characters. column width is 111 at font10 . Is there a fix? without going to larger monitors.

excel2002

**ratcat** · 10-27-2008, 03:17 PM

G'day Jen,

and welcome to the forum.

To make your data validation larger, click on the link below.

http://www.contextures.com/xlDataVal08.html#Font

HTH

**Jen is me** · 10-27-2008, 04:33 PM

OK I followed directions on link and I see what you are suggesting. And I tried it. But making the column longer or increasing to higher % with the view code does not help. Longer is still out of view far left. Higher % places the drop down arrow out of view on the right.

Is there no way for the drop down list to "center"

**Jen is me** · 10-27-2008, 05:31 PM

okay if I use your suggeston of view code zoom AND reduce the column width it fixes my problem. thank you so much!

**ratcat** · 10-28-2008, 01:06 AM

Originally Posted by Jen is me

okay if I use your suggeston of view code zoom AND reduce the column width it fixes my problem. thank you so much!

If that works for you.......why not !!

Thanks for the thanks and your welcome back at anytime when you need help.

May I ask of one thing ? Can you please 'Solved' the thread.

Originally Posted by Site Admin

1) Click the EDIT button on your first post
2) Click the GO ADVANCED button
3) Select SOLVED from the Title dropdown (under the Reason for Editing box)
4) Click the SAVE CHANGES button

Note: If it's more than 2 days after your first post, please ask a moderator to mark the thread SOLVED for you.

Regards,
Site Admin.

Cheers