Are you typing data directly into Excel?
(Rather than exporting it from a database?)
If so, drop-down lists can save time and reduce typos.
Here’s how to make them in Excel with a feature called Data Validation:
Related resources:
Are you typing data directly into Excel?
(Rather than exporting it from a database?)
If so, drop-down lists can save time and reduce typos.
Here’s how to make them in Excel with a feature called Data Validation:
Great article, Ann! Your tips on using data validation for drop-down lists are super helpful, especially for cutting down on typos. Have you covered how to link these lists across multiple sheets yet? Thanks for making Excel less daunting!
Our weekly newsletter is shared with a community of 8,000 professionals.
1 Comment
Great article, Ann! Your tips on using data validation for drop-down lists are super helpful, especially for cutting down on typos. Have you covered how to link these lists across multiple sheets yet? Thanks for making Excel less daunting!