Instructions for using Dropdown Chips in Google Sheets
Dropdown Chips in Google Sheets is a new feature added to sheets for you to easily enter data or facts or anything. This Chips Dropdown tool also helps you create drop-down lists on Google Sheets, create any cell selection for you to enter data and various content. Users can create different rules depending on the data, or choose different colors for selections. The following article will guide you to use the Dropdown Chips tool in Google Sheets.
How to use Dropdown Chips in Google Sheets
Step 1:
First we will insert the chip dropdown tool in the document. In the cell you want to insert, click Insert and then select the drop-down menu in the displayed list.
Instructions for using Dropdown Chips in Google Sheets Picture 1
Step 2:
Next on the right edge of the screen you see the content input interface for this chip dropdown tool. First, the data area used by the chip dropdown will show up under Apply to range .
Instructions for using Dropdown Chips in Google Sheets Picture 2
Step 3:
Scrolling down to the Criteria area will see there are many different types of content for users to choose from. We can select Drop-down menu to create custom options for drop-down menu.
Instructions for using Dropdown Chips in Google Sheets Picture 3
Depending on the criteria you choose, the custom content below will be different for you to set up for the selected content area.
Instructions for using Dropdown Chips in Google Sheets Picture 4
Step 4:
Now you fill in optional content for the criteria we have selected. With this type of Drop-Down Menu you fill the options and colors with the option that comes with it.
Instructions for using Dropdown Chips in Google Sheets Picture 5
We continue to fill in different options according to the requirements of the content. In each selected content, there will be a trash can icon to delete if you don't want to use it, and adjust the order of options .
Instructions for using Dropdown Chips in Google Sheets Picture 6
Step 5:
Scroll down below and click on Advanced options to set up.
Instructions for using Dropdown Chips in Google Sheets Picture 7
Display advanced options, you tick the content you want to install for the drop-down list above. Finally click on Done to save the content.
Instructions for using Dropdown Chips in Google Sheets Picture 8
Step 6:
The resulting content has been displayed in the area you selected as shown below.
Instructions for using Dropdown Chips in Google Sheets Picture 9
How to Edit Dropdown Chips in Google Sheets
Step 1:
You click on the drop-down list and then click on the edit icon in the right corner as shown below.
Instructions for using Dropdown Chips in Google Sheets Picture 10
Step 2:
Then also display the interface to edit the data area drop-down menu for you to change again as required. After making changes, click the Done button to save .
Instructions for using Dropdown Chips in Google Sheets Picture 11
The content results have been changed, such as changing the color of the selections.
Instructions for using Dropdown Chips in Google Sheets Picture 12
Step 3:
In case you want to delete the drop-down menu , click on the data area and then select Delete all .
Instructions for using Dropdown Chips in Google Sheets Picture 13
You should read it
- Use Dropdown in CSS
- Tricks using Google Sheets should not be ignored
- How to create graphs, charts in Google Sheets
- How to align spreadsheets before printing on Google Sheets
- 6 useful functions in Google Sheets you may not know yet
- How to convert Google Sheets to PDF
- How to enter 0 in Google Sheets
- How to create a phone number can be called on Google Sheets
- How to view editing history on Google Sheets
- How to fix Google Sheets not allowing scrolling
- How to count words on Google Sheets
- How to set up the right to edit spreadsheets on Google Sheets