Wednesday 16 December 2009

Data Validation 5 - Create Drop Down Menus That Accept Other Values in Excel

Title:
Data Validation 5 - Create Drop Down Menus That Accept Other Values in Excel


Video:


Description:Visit www.TeachMsOffice.com formore, including Excel Consulting, Macros, and Tutorials. Excel video tutorial that describes how to enter data into cells that contain drop down menus using data validation. This method teaches you how to be able to enter data into a data validated drop down menu cell that is not contained within the drop down menu. Basically, you will be able to enter values that are not contained in the drop down menu into a cell with a drop down menu. This allows you to simply use the data validation drop down menu feature in Excel in order to make entering values in cells easier for users while at the same time not preventing them from entering other values. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!

Published:
17/Dec/2009

No comments:

Post a Comment