Data Validation -> Validation list is larger than the cell width

[Barb Reinhardt]

I have a workbook that I've just added data validation to one cell. FWIW,
the data validation is based on a named range. Here's the (perceived)
problem. When I've set up data validation in the past, the selection is the
same width as the cell. In this case, the list starts almost a full cell
width to the left. What am I missing?

Thanks,

Barb Reinhardt

 

[ker_01]

Barb,

In Excel2003 I can replicate what you describe under the following conditions:

1. the named range contains entries that are wider than the data validation
cell
2. The data validation cell is right-justified

If you change the cell justification for the data validation cell to
left-justified, do you still have the same problem? If so, are you working in
03 or 07?

HTH,
Keith