drop down tags

[steve dawson]

Can anybody help me? i am trying to make a spreadsheet
with drop down tabs in every column on the worksheet. i
understand this may be something to do with macros?

 

[Max]

Data Validation will do this job quite nicely.

MVP Debra Dalgleish has good coverage of this at:
http://www.contextures.com/xlDataVal01.html