View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
peabrain25
 
Posts: n/a
Default How to indicate a cell has a validation list associated to it?

Mike,

A simple solution may be to just add a selection like <Select One to your
data validation list and have that populate the cells when the workbook is
opened.

Thanks,
Mark


"Mike" wrote:

Excel 2002...I have several cells that have Validation lists associated
within them. When I select the cell I see the indictor that there is a list
attached. I want to know if there is a way to indicate that there is a list
atached to all th cells without having to selct the cells....so that somone
coming up on the spreadsheet will know just by looking which cells have lists
associated with them.