Thread: Get rid of empty cells when displaying Data validation list
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
  
Posts: 427
Default Get rid of empty cells when displaying Data validation list
One solution would be to go to the cell range that is referenced by
your data validation list and sort it. That would move empty cells to
the bottom of the list, out of the way.

Reply With QuoteReply With Quote