Using the drop down list values in a cell

  1. In the Cell, Click Data >Data Validation.
  2. On the Settings tab, in the Allow box, click List. In the Source box, type and equal sign (=), immediately followed by the name you gave your list in step 3. For example, =Categories

Creating a drop down list of values

  1. On a new worksheet, type the entries that you want to appear in your drop-down list. The entries should be in a single column or row without any blank cells, like this

  2. Select all of your entries, right-

  3. click, and then click Define Name.

Anuj holds professional certifications in Google Cloud, AWS as well as certifications in Docker and App Performance Tools such as New Relic. He specializes in Cloud Security, Data Encryption and Container Technologies.

Initial Consultation

Anuj Varma – who has written posts on Anuj Varma, Hands-On Technology Architect, Clean Air Activist.

 Twitter Linkedin