Data Validation 1 - Create Drop Down Menus in Excel

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
6,753
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Dec 15, 2009

Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials.

Step by step guide to creating drop down menus in Excel. This Excel video tutorial shows you how to use data validation in Excel in order to make a drop down menu that displays from any cell within a worksheet. This is a great tutorial for anyone who is not familiar with data validation but who still needs to make a drop down menu in Excel.

The real benefit to using drop down menus in Excel is that you can make it easier for a user to enter the correct value into a cell. This works well when creating a user form from an Excel worksheet.

For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.

Have a great day!

Category:

Education

Tags:

License:

Standard YouTube License

  • likes, 4 dislikes

Link to this comment:

Share to:
see all

All Comments (2)

Sign In or Sign Up now to post a comment!
  • Nice Job!

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more