There are certain times and conditions when you feel the need that other people can only edit or add and modify data from selected cells in your Excel sheet. The rest of the cells in the sheet or workbook must be un-editable. Example of these Excel sheets are survey questionnaires wherein other people can just input their answers but not alter the questions. Others can be a fillable form wherein other people can just enter their personal or other information but the form content and layout are locked for editing…. Read More
Posts tagged Microsoft Excel Tips
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