How to create dropdown in google sheets

How to create dropdown in google sheets

 

Hello friends in this article we learn how to create dropdown in google sheets. Using Google Sheets, if we use the same thing repeatedly in any row, column and cell, then we can keep a drop down list of them so that we do not have to write all those things again and again.

How to create dropdown in google sheets?

First, you have to open your Google Sheet, after that right-click on any one cell, and after that, you have to select the option with data validation. After that you have to select the list of items in the criteria and then After that, you have to select the list of items in the criteria after that, you have to type all your options in the box in front with a comma, and then press save button.

 

How to create dropdown in google sheets

How to create dropdown in google sheets

How to create dropdown in google sheets

after that, you can drag and drop or copy and paste this into all row. I hope you learned how to create dropdown in google sheet.

Thanks for reading this article, Keep Learning.