Drop down list button hidden

C

Cathy Landry

Good Morning,

My drop down list contains ship to addresses. Some are long and when I try
to choose another address, the arrow is hidden because the formula bar that
is showing my addresses hides the drop down arrow. Can I move the arrow but
keep the data in the same field?

Thank you
Cathy
 
D

Debra Dalgleish

You can't move the arrow, but you could restore the Workbook window, by
using the control buttons at the top right. Then, move the window down a
bit, within the Excel window, so it's not obscured by the formula bar.
 
C

Cathy Landry

Thank you Debra, I will try that. I just didn't want our purchasing techs to
have to manipulate the po form/window if they didn't have to. They're used to
the paper forms!
 
D

Debra Dalgleish

Can you make the first rows tall enough that the address row is below
the enlarged formula bar?
 
C

Cathy Landry

I will try that!

Thank you for your help
Cathy

Debra Dalgleish said:
Can you make the first rows tall enough that the address row is below
the enlarged formula bar?
Click to expand...
 
Top