Posts tagged Excel Data Validation

Microsoft Excel: Using Data Validation to provide drop-down selection menu

In Excel, there are various ways to provide a drop-down menu in a form or in cells. With drop-down menus, also called combo boxes, you can select an option based on pre-selected data. Samples of data where drop-dowm menus will be useful are gender (Male and Female options), Status (Single, Married, Divorced, etc options) and many others. The major reasons for providing a combo box or drop-down selection menu includes the following: On the other hand, combo boxes or drop-down selection menus are only applicable when: In this article, I… Read More

Data Validation drop-down boxes are missing in a different version on Excel

How Tos MS Office Tips Tips & Tricks August 11, 2022

MS Excel has some known inconsistency or incompatibility when it comes to its data validation list feature. The exact problem is that, if your file contains data validation lists created in Excel 2007, these data validation lists are gone when you open it in Excel 2010. If this “data validation” thing in Excel is new to you or something that you have not tried so far, please read this article for the complete and detailed procedures in creating and using data validation lists: http://www.technicalforum.org/ms-office/excel-200720102013-using-data-va… Let us take as an example… Read More