Explanation

A Drop-down List allows users to select a value instead of typing it manually.

Go to:

Data → Data Validation → Allow: List

Example

Department list:

  • Sales
  • HR
  • IT
  • Finance
  • Marketing

Cell B2 will display a drop-down arrow.

Source

You can directly enter:

Sales,HR,IT,Finance,Marketing

or use a range such as:

=$H$2:$H$6

Practice

Create drop-down lists for:

Department

Sales, HR, IT, Finance

City

Sirsa, Hisar, Fatehabad, Abohar

Category

Accessories, Hardware, Software

PreviousNext