Friday, May 11, 2012

Excel Dropdown in Cells

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.

  • 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.



Search Flipkart Products:
Flipkart.com

No comments: