Apart from creating a simple Drop Down Menu/List or Data Validation List, you can expand this concept to include it in your Excel Table or Database.

Watch how to insert a Data Validation List

That way you don’t have to do repetitive tasks like entering the same customer over and over again or copying and pasting time and time again.

See how easy it is to implement this in under 1 minute!

DOWNLOAD WORKBOOK

Data Validation List in Tables

Helpful Resource:

MOTH-excel_expert470x63

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin