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

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Add Hyphens To Serial Numbers Using Excel Flash Fi...  Flash Fill in Excel is a new feature that was introduced in Excel 2013.Flash Fill allows you to combine, extract, move & transform data that belongs in one column, into a new column.One of the cool uses of Flash Fill is formatting numbers.  In our example be...
Data Bars, Color Scales & Icon Sets Conditional Formatting has improved in Excel 2010 with the introduction of Data Bars, Color Scales & Icon Sets.Data Bars: Includes graphic bars in a cell, proportional to the cell’s value - Good for Financial AnalysisColor Scales: Includes a background color, proporti...
Custom Number Formats in Excel A custom number format in Excel can have up to four different sections in the following order: Positive format; Negative format; Zero format; Text format  You can specify different format codes for each section as long as they are separated by a semicolon.So you ca...
Row Differences If you have two rows that you want to compare, for example, sale amount versus amount paid, you can easily filter the differences between these two columns by going in to the Find & Select > Go To Special > Row Differences.Once the cells have been identified, you ca...