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!

Drop Down Menu In Your Excel Table | MyExcelOnline

DOWNLOAD WORKBOOK

STEP 1: Have your list of values ready

Drop Down Menu In Your Excel Table | MyExcelOnline

STEP 2: Highlight the area that you want to place your drop down list on

Drop Down Menu In Your Excel Table | MyExcelOnline

STEP 3: Go to Data > Data Validation

Drop Down Menu In Your Excel Table | MyExcelOnline

Select List and for the Source, select the list of values for your drop down list. Click OK.

Drop Down Menu In Your Excel Table | MyExcelOnline

STEP 4: You can test it out now on your table! You can also update the values in your source list and it gets reflected in your drop down list!

Drop Down Menu In Your Excel Table | MyExcelOnline

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

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn