Is there any way to change the internal format of drop-down lists to a
monospace font such as courier? I have some drop-down lists whose
contents I would prefer line up more closely. As an example:

3-4 Steps <tab over> 6
5-7 Steps <tab over> 10


Such that I essentially have two columns in the drop-down list, each
left-aligned. Currently, it is very difficult to make the 6 and 10
align for instance, and even when accomplished manually it will change
if the zoom percent is altered.

Any help would be most sincerely appreciated.

Take a look at Debra Dalgleish's site here:

http://www.contextures.com/xlDataVal10.html

where she describes using a Combo box for the drop down, which can
then be changed in a variety of ways.

Hope this helps.

Pete

On Sep 20, 9:11*pm, Russ Thomas <russthoma...@gmail.com> wrote:
> Is there any way to change the internal format of drop-down lists to a
> monospace font such as courier? I have some drop-down lists whose
> contents I would prefer line up more closely. As an example:
>
> 3-4 Steps <tab over> 6
> 5-7 Steps <tab over> 10
>
> Such that I essentially have two columns in the drop-down list, each
> left-aligned. Currently, it is very difficult to make the 6 and 10
> align for instance, and even when accomplished manually it will change
> if the zoom percent is altered.
>
> Any help would be most sincerely appreciated.

Pete,

Thank you for the link. It looks quite useful and hopefully will do
the trick. Thanks for the timely response and aid.

Russ

You're welcome, Russ - thanks for feeding back.

Pete

On Sep 20, 10:30*pm, Russ Thomas <russthoma...@gmail.com> wrote:
> Pete,
>
> Thank you for the link. It looks quite useful and hopefully will do
> the trick. Thanks for the timely response and aid.
>
> Russ