Drop Down List Contains the List Header Row

[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.

 

[Jacob Skaria]

--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)