Struggling to gather all of your info in Google Sheets ? Try creating a drop - down menu to display all of your statistics in short .
Google Sheets allow for you to make spreadsheet directly in your web internet browser and comes with a lot of handy features . One of the honest feature of Google Sheets is the power to add drop - down menus , to make organising your workplace even well-situated .
If you want to get wind how to create and edit a drop - down menu in Google Sheets , keep read , as we ’re going to be running through the process with a simple tone - by - step guide .
What you’ll need:
The Short Version
Step 1.
Open a new spreadsheet
Open a newfangled Google Sheets spreadsheet on your PC .
Step 2.
Select the cells where you want to create a drop-down list
pick out all the jail cell where you want to make a drop - down listing by snap and drag out over them .
Step 3.
Click Insert
From the menu at the top of the screen , click Insert .
Step 4.
Go to Drop-down
Select Drop - down from the menu .
Step 5.
Add another item if needed
If you need to add more item in your drop - down fare , come home on Add another point .
Step 6.
Label all the items
Label all of your drop - down items .
Step 7.
Add colours if needed
If you want to supply colours to all your driblet - down carte du jour point , take them now .
Step 8.
Click Advanced options
select forward-looking options .
Step 9.
Select all options you require
Select any options in this section that you require for your drop cloth - down menu .
Step 10.
Click Done
Once you are happy with your drop-off - down computer menu , click Done .
Step 11.
Insert your drop-down menu
Insert your drop - down menu items .
Troubleshooting
Yes , you may delete your free fall - down menu at any time once it has been create .
Yes , you’re able to blue-pencil a drop - down carte du jour create in Google Sheets if you involve to .
