How To Make Dropdown List In Google Sheets

Google Sheets affords the function of Knowledge Validation. Knowledge validation limits the information that may be entered right into a cell. You would use this function to create a drop-down record in Google Sheets. This function will be particularly useful once you’re making an attempt to gather quantitative knowledge.

In case you’ve landed on this web page, we assume you’re keen on making a dropdown record in Google Sheets. On this article, we’ve introduced detailed directions on how you may use Knowledge Validation to create a dropdown record on Google Sheets so keep studying!

How to Make Dropdown Record in Google Sheets

There are two methods you may use Knowledge Validation in Google Sheets to create a drop-down menu. You would both add a brand new record of knowledge or current knowledge from the sheet as your choices for the drop-down menu.

Consult with the next steps to create a Dropdown record in Google Sheets:

1. Open your worksheet.
2. Choose the cell you want to place your drop-down menu.
   
3. From the menu bar, choose Knowledge > Knowledge Validation.
   
4. Within the Knowledge Validation tab, drop the menu down subsequent to Standards:
   • Record from a spread: In case your knowledge is within the sheet, choose this selection, then enter the vary within the message field subsequent to it.
   • Record of things: In case you should not have the information current within the sheet, choose this selection, then enter the information gadgets within the field subsequent to it. To separate every worth, use the comma (,) signal.
     
5. Configure the response for invalid entry and look accordingly.
   
6. Choose Save.
   

You may increase the cell with validation to the corresponding rows and/or columns utilizing Flash Fill. Merely place your cursor on the bottom-right nook of the cell and drag throughout the row or column. 

How to Apply Formatting within the Dropdown Record?

You would apply conditional formatting to your record to make it look higher. For instance, you could have created a dropdown record to update the standing of a lead. You would format the Confirmed standing as inexperienced, Pending as yellow, and Rejected as crimson.

In case you’re keen on utilizing conditional formatting within the dropdown record, observe these steps:

1. Choose the cells with the information validation.
2. From the menu bar, choose Format > Conditional Formatting.
   
3. On the Conditional format guidelines panel to your left, drop the menu for Format cells if.
   
4. Choose Textual content Incorporates.
5. Enter your first worth. For this instance, we’ve entered Confirmed.
6. Choose Default beneath Formatting Fashion and select a colour. We’ve left the colour inexperienced for this instance.
   
7. Click on Completed.
8. Choose Add one other rule, then repeat the steps for the remaining values.
   

After making use of the settings, each time you choose the formatted worth, the cell is crammed with the set colour. 

How to Edit or Delete Dropdown Record?

You would simply create adjustments or take away the dropdown record out of your spreadsheet. To clear or edit the dropdown record, you’ll have to alter or take away the information validation you could have utilized on the cell. 

Consult with the next steps in case your want to edit or delete the dropdown record you created via Knowledge validation:

1. Choose the cell with the dropdown record.
2. Head to Knowledge > Knowledge Validation from the menubar.
3. In case you want to edit the choices, make your adjustments within the message field within the Standards part.
   
4. Choose Take away Validation.