01/11
Open a new Google Sheets spreadsheet on your PC.
Open a new spreadsheet
02/11
Select the cells where you want to create a drop-down list
Select all the cells where you want to create a drop-down list by clicking and dragging over them.
03/11
From the menu at the top of the screen, click Insert.
Click Insert
04/11
Go to Drop-down
Select Drop-down from the menu.
If you need to add more items in your drop-down menu, click on Add another item.
Add another item if needed
05/11
06/11
Label all of your drop-down items.
Label all the items
07/11
Add colours if needed
If you want to add colours to all your drop-down menu items, select them now.
Select all options you require
09/11
Select any options in this section that you require for your drop-down menu.
Click Done
Once you are happy with your drop-down menu, click Done.
10/11
Insert your drop-down menu
11/11
Insert your drop-down menu items.