Validating drop down list

Posted by / 12-Aug-2019 07:07

The resulting string will be something like this: “=Sheet1!

Create a drop down list of items in a cell, with Excel's Data Validation feature.

If they are in separate sheets you would use a statement like “=Sheet Name!

A1: A6”, where “Sheet Name” is replaced with the name of the sheet.

To create a named range, select the cells that will be on the list, and name the selection.

For example, if you change Oatmeal Raisin to Shortbread, the drop-down list shows the new entry.Creating a drop-down list in Excel lets you enter data into a specific cell of a worksheet from a preset list of entries.Once you create the drop-down list, editing the entries is as easy as changing the cell data.In this example, the data is pulled from a cell that's located in a different worksheet.A named range lets you refer to the list data as a common name instead of as individual cells.

validating drop down list-60validating drop down list-86validating drop down list-61