Home OS Windows How to create and modify a drop-down list in Google Sheets

How to create and modify a drop-down list in Google Sheets

Google Sheets is a free web-based utility and a well-liked various to Microsoft Excel. The software permits to simply create, replace, and modify spreadsheets. It serves as a wonderful collaborative software permitting you so as to add as many individuals as you need and edit Google Sheets with others on the identical time. The on-line software lets you work collectively in real-time on a undertaking in the identical spreadsheet no matter wherever you’re situated. To collaborate on Google Sheets one has to easily click on a Share button and there you’re permitting your folks, colleagues, or household to edit your spreadsheet.

When engaged on a shared Google Spreadsheet, it’s your decision different customers to enter solely restricted information inside its cells. To keep away from others coming into flawed values inside cells, chances are you’ll need to add a graphical management aspect just like the drop-down menu which is analogous to a listing field that may permit individuals to enter solely these values obtainable from a given checklist. Apart from that, the drop-down checklist serves as a sensible and extra environment friendly methodology to enter information.

That being stated, a drop-down checklist or a pulldown menu is a streamlined approach to make sure that individuals fill solely the values into your cells in the very same method as your anticipating. Like Excel,  Google Sheets means that you can simply create a drop-down menu to your Sheets. Additionally, it lets you make partial adjustments to the drop-down checklist in case you need to modify the choice checklist within the cells.  In this text, we clarify intimately methods to create a drop-down menu in Google Sheets and modify the identical.

Create a drop-down menu in Google Sheets

Launch Google Sheets

Open a brand new spreadsheet or open an current spreadsheet file.

Select a cell the place you need to create a drop-down checklist. You can even choose a bunch of cells, a whole column, or a row.

Navigate to Sheets menu and click on on the choice Data.

create and modify a drop-down list in Google Sheets

Select Data Validation from the drop-down menu. A Data Validation window pops up with a number of choices to customise.

The first discipline within the Data Validation window is the Cell vary which is robotically crammed based mostly on the chosen cells. You can change the vary to a brand new worth by merely clicking on a desk icon within the Cell Range discipline.


The second discipline within the Data Validation window is the Criteria which has a listing of assorted choices in its personal drop-down menu. The Criteria incorporates choices like List from a variety, List of things, Number, Text, and Date. 



  • List from a variety: This possibility means that you can create a listing of values which have been retrieved from totally different sheets or the checklist of values from totally different cells on the identical sheet.
  • List of things: This permits us to create a  checklist of textual content values. They are entered within the edit discipline separated by commas.
  • Number: This Option doesn’t create a drop-down checklist as an alternative makes positive that the entry to the drop-down menu falls inside a selected numeric vary.
  • Text: This Option doesn’t create a drop-down checklist as an alternative makes positive that the entry is in a correct textual format.
  • Date: This Option doesn’t create a drop-down checklist as an alternative makes positive if the date entered is legitimate or is available in a sure vary.
  • Custom Formula is: This possibility doesn’t create a drop-down checklist as an alternative makes positive the chosen cell makes use of a user-specified components.

Once the info that’s to be included within the checklist is entered, choose the choice Show dropdown checklist in cell. Selecting this selection ensures that the values seem within the cells.

You can even select what must be completed when somebody enters an invalid information which isn’t current on the checklist by choosing the choices with a radio button. You can select to have both Show warning possibility or Reject enter possibility on invalid information. The Reject Input possibility doesn’t will let you enter any worth which isn’t current in your drop-down checklist. On the opposite hand,  Show warning possibility means that you can enter the invalid information which isn’t in your checklist however shows the warning message within the sheet.


The final possibility within the setting window is the Appearance. This possibility offers a touch to the person on what values or information they’ll enter within the cells. To activate this assistant, choose the choice Show validation assist textual content beside the Appearance discipline.  After you choose the choice, sort the directions that need to give individuals about what values they’ll select inside the cell vary.

Click Save to use the adjustments.

Edit the drop-down checklist in Google Sheets

To add extra values to the checklist or take away gadgets from the drop-down menu observe the beneath steps

Navigate to Data and choose Data validation from the drop-down menu.

Select the cells and alter the gadgets within the entry.

Click Save to use adjustments.

That’s all.

Most Popular

Recent Comments