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

B

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
 
K

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top