Data Validation Lists


To avoid entering incorrect product codes, account names, surnames…

To limit options to a pre-populated list try creating a Data Validation List using Excel.

  1. Type a list of Statespicture2
  2. Select the cell/s to apply the list to
  3. Data Tab, Data tools group
  4. Select Data Validation
  5. In the Allow field
  6. Choose List form the drop down arrow
  7. In the Source Field
  8. Select the range of cells with the States
  9. You know have a drop down arrow to select a state for your data entry.

picture3

Related Topics

Compatibility Mode on Microsoft Office apps

Why does my formula say [@Qty]

Wrap Text in Excel

Quick Formatting in Excel

 

Advertisements

About Customised Computer Courses Sydney - Sutherland Shire M 0414 417 059

On-Site customised computer training courses Sydney - Sutherland Shire. Excel, Word,Power Point, Access, Outlook, Visio, Publisher, Excel VBA e: Info@azsolutions.com.au m: 0414 417 059 www.azsolutions.com.au
This entry was posted in Excel. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s