Is this because you've reserved extra rows so that you can plop in additional
entries without worring about changing the data|validation list.

If yes, you may want to consider naming your range and use the techniques at
Debra Dalgleish's site:
http://www.contextures.com/xlNames01.html#Dynamic

You can create this dynamic range name that will grow and expand based on the
number of entries in the list.

mbeauchamp wrote:

My Data Validation list includes empty cells. I would like to get rid of
those empty cells when this list is displayed when I click the arrow to show
the valid entries.

Thanks

Michel

--

Dave Peterson