In EXCEL, there are occations where we want to restrict the user to enter/select only specific values in certain cells.
For example let us take a Status column, which can have values Open, Work In Progress, Closed & Pending clarification. If we allow the users to enter the values manually, chances are that each user will enter his own value, or there could be a typo error, to avoid all these we add a dropdown list to the cell and make the user to select from the specific list of value, here is how we do that.
In this sample i am using Excel 2007 version.
That's it the free cell will now become a DropDown list restricting users to select values from the DropDown.
For example let us take a Status column, which can have values Open, Work In Progress, Closed & Pending clarification. If we allow the users to enter the values manually, chances are that each user will enter his own value, or there could be a typo error, to avoid all these we add a dropdown list to the cell and make the user to select from the specific list of value, here is how we do that.
In this sample i am using Excel 2007 version.
- Select the cell which needs to have a DropDown.
- In the Menu bar, select Data tab
- Select Data Validation in the Data Tools group
- Select List in the Allow Option
- In the Source TextBox type the possible values seperated by commas.
- Click OK.
That's it the free cell will now become a DropDown list restricting users to select values from the DropDown.
