View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tonso Tonso is offline
external usenet poster
 
Posts: 90
Default alignment in a validation list

is there a convenient way in xl2003 to line items up left aligned and
right aligned in a drop down list.
example

red roses 1
white roses 10
purple pansies 275

the names are left aligned, and the numbers are right aligned.

i can create the list, and tinker with it by adding/deleting spaces
until they are aligned in the dropdown list, but i was wondering if
ther was a better way, as the list is very long.



thank you,

Tonso