Drop Down List Contains the List Header Row

  • Thread starter Thread starter Glenn
  • Start date Start date
G

Glenn

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
Data>Validation, 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.
 
--In source mention the formula as $H$2:$H$10

--If you want to create a dynamic named range as below..

Enter the below formula in Data>Validation>List>Source to have the list from
H2 to Hn where Hn is the last entry in that column......

=OFFSET($H$2,,,COUNTA($H:$H)-1)
 
Back
Top