+4 votes
159 views
in Sell ​​on the Internet by (242k points)
reopened
Create drop-down lists with Google Sheets

1 Answer

+5 votes
by (1.6m points)
edited
 
Best answer

Why dropdown fields are important
Create Dropdowns in Google Sheets: Step-by-Step Instructions

image

Create drop-down lists with Google Sheets

Spreadsheet programs help to represent complicated data clearly and concisely. Attribute mappings can be extremely useful when ranking values ​​and data. If you don't want to have to manually enter a value's attributes into its corresponding cell every time they appear, drop-down lists are a great advantage. These lists allow the user to select from several predefined attributes. Here we explain how to create drop-down lists in Google Sheets..

Index
  1. Why dropdown fields are important
  2. Create Dropdowns in Google Sheets: Step-by-Step Instructions

Why dropdown fields are important

A drop-down list allows one click to select predefined values ​​from a sequence. The selected value will then be displayed in the cell, making it easy to select, since the value does not have to be typed by hand. You can also use dropdowns to make sure the data is consistent and correct. If multiple users work on a table, predefined values ​​can be used in the drop-down lists to ensure that users can only make correct entries. This results in fewer misprints and huge time savings - good reasons to create Google Sheets dropdowns.

advice

In our comparison between Google Sheets and Excel, you can see how Google and Microsoft spreadsheets differ..

Create Dropdowns in Google Sheets: Step-by-Step Instructions

Google has made it as easy as possible for its users to edit dropdown fields in individual cells. To create them, follow these steps:

Step 1: Select a cell with the right button and click? Data validation ?:

image
Click the right mouse button on the cell where you want to add a drop-down list. Select the menu item? Data validation ?.

Step 2: in the section? Criteria ?, select? Item list ?:

image
In the configuration menu? Data validation ?, select? List of items? in the? Criteria? submenu.

Step 3: After selecting? List of elements ?, in the next free text field type all the elements of the list manually . Each item must be separated by a comma. Then click? Save ?

image
In the data validation menu you must enter by hand the fields that should make up your drop-down list.

Step 4: In the selected cell, a drop-down menu will have been created. This is indicated by the down arrow in the cell.

image
Cell with drop-down menu in Google Sheets.

Step 5 : Click the arrow to open the drop-down menu. Check if the items are listed in the desired sequence and spelled correctly. If you want to make changes, go to the menu item? Data validation? and modifies the list of elements in the submenu? Criteria ?..

image
Items in a Google Sheets drop-down list are automatically sorted in the order in which they were listed in the data validation menu.

Step 6 : in the menu? Data validation ?, you can check the option? Show help text for validation ? to the right of? Appearance ?. When you check it, a field will appear below where you can add an explanatory text that will appear when you hover over the drop-down menu.

image
A help text assists the user to use the generated drop-down menus.

The result looks, for example, like this:

image
Help text is highlighted. In this way, the user knows how to proceed.

Step 7: If you want to clear the drop-down menu, go back to? Data validation? and press the button? Remove validation ?. The selected cell will be unformatted again and can be filled with other values.

image
The button? Remove validation? is available after defining a drop-down list for a cell.
advice

Our article on "Conditional Formatting in Google Sheets - How to Apply It Easily" might also interest you.


...