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.

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 1Instructions 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 2Instructions 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 3Instructions 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 4Instructions 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 5Instructions 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 6Instructions 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 7Instructions 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 8Instructions 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 9Instructions 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 10Instructions 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 11Instructions 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 12Instructions 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 13Instructions for using Dropdown Chips in Google Sheets Picture 13

5 ★ | 1 Vote