Display year selection dropdown in a calendar

1. How do I add a year to a drop down list in Excel?

How do I add a year to a drop down list in Excel?

Go to Data > Data Validation. On the Settings tab, click in the Source box, and then on the worksheet that has the entries for your drop-down list, Select cell contents in Excel containing those entries. You'll see the list range in the Source box change as you select.