Step by Step guide to assist you create drop down menu in Google Sheets

Google sheets lets users use features which help in managing data better. Creating drop down menu is one of such feature. Let us see the steps for doing that.

How to add drop down menu in Google Sheets

How to add drop down menu in Google Sheets

  1. Select the cell in Google Sheets.
  2. Go to Data -> Data Validation -> Criteria -> List of items / List from a range.
  3. Enter the values which you want to show in drop down.
  4. That is it.

Important

With this drop down, you can select the value and use it in the google sheet. If you have any questions, drop down the comments below.

Leave a Comment

%d bloggers like this: