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.

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 .

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.

Depending on the criteria you choose, the custom content below will be different for you to set up for the selected content area.

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.

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 .

Step 5:

Scroll down below and click on Advanced options to set up.

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.

Step 6:

The resulting content has been displayed in the area you selected as shown below.

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.

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 .

The content results have been changed, such as changing the color of the selections.

Step 3:

In case you want to delete the drop-down menu , click on the data area and then select Delete all .

Isabella Humphrey

Update 01 June 2023