View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
glenn glenn is offline
external usenet poster
 
Posts: 122
Default Drop Down List Contains the List Header Row

Hello,

I've created a list that contains a header in A1 on a separate worksheet
within the same workbook. When I created the drop down list using
DataValidation, the drop down list contains the header row name from A1.
How can I keep the header row name from appearing as a choice in the drop
down list?

Thanks everyone for any help.