In this tutorial, we will learn How to Create Categories in Google sheets
How to Create Categories in Google sheets( Overview of steps )
- Open Google Sheet
- Create a new worksheet with a list of category
- Identify and Note the cell range for the list of drop-down categories
- Now Choose the column where you want to display the Category drop-down list.
- Click on the Data menu and Choose “Data Validation ” from the drip-Down
- Select Data Range on the Data Validation screen
- Select cell Range from the Second worksheet for the list of items for drop-down
- Click on Save to apply the Data Validation selection
- Required categories are created with a drop-down list in Google Sheet.
Let’s go through the above steps in detail.
How to Create Categories in Google sheets: Step by Step Guide
Enclosed are the steps to create categories in Google Sheets:
We will first create the required items required by the Category drop-down items in the second worksheet and then display a list with the category drop-down list in the first worksheet.
Step 1: Open Google Sheet
Step 2: Create a new worksheet with a list of category
Create a new worksheet and type the list of items that you want to appear as drop-down items.
For example, we have created a new worksheet called Movie Genre
![How to Create Categories in Google sheets](https://ml6efdvut7qo.i.optimole.com/Sjge_4I-r5Wo9dpn/w:262/h:191/q:auto/https://addnewskills.com/wp-content/uploads/2022/06/image-26.png)
Step 3: Identify and Note the cell range for the list of drop-down categories
![](https://ml6efdvut7qo.i.optimole.com/Sjge_4I-05F4acAE/w:auto/h:auto/q:auto/https://addnewskills.com/wp-content/uploads/2022/06/image-25.png)
Step 3: Now Choose the column where you want to display the Category drop-down list.
Go back to the first worksheet and Select the Columns where you need to display a drop-down
![](https://ml6efdvut7qo.i.optimole.com/Sjge_4I-2nPH4cgB/w:auto/h:auto/q:auto/https://addnewskills.com/wp-content/uploads/2022/06/image-20.png)
Step 4: Click on the Data menu and Choose “Data Validation ” from the drip-Down.
- Click on the Data menu on the Main menu bar.
- Now from the drop-down options
![](https://ml6efdvut7qo.i.optimole.com/Sjge_4I-9oZJwsz5/w:auto/h:auto/q:auto/https://addnewskills.com/wp-content/uploads/2022/06/image-21.png)
Step 5: Select Data Range on the Data Validation screen
- Once you click on” Data Validation“, Data Validation windows will pop-up
- Now Click on the “Select Data Range” option in front of the “List from a Range” criteria as shown below
![](https://ml6efdvut7qo.i.optimole.com/Sjge_4I-VWG8VCg1/w:auto/h:auto/q:auto/https://addnewskills.com/wp-content/uploads/2022/06/image-27.png)
Step 6: Select cell Range from the Second worksheet for the list of items for drop-down
Once you click on the “Select data range” option, a new window will pop up.
![](https://ml6efdvut7qo.i.optimole.com/Sjge_4I-Y4-qnOS4/w:auto/h:auto/q:auto/https://addnewskills.com/wp-content/uploads/2022/06/image-28.png)
- Switch to the second worksheet, Select the cell Range and Click on OK.
![](https://ml6efdvut7qo.i.optimole.com/Sjge_4I-29CaLweo/w:auto/h:auto/q:auto/https://addnewskills.com/wp-content/uploads/2022/06/image-29.png)
Step 7: Click on Save to apply the Data Validation selection
![](https://ml6efdvut7qo.i.optimole.com/Sjge_4I-Mqxk4p81/w:auto/h:auto/q:auto/https://addnewskills.com/wp-content/uploads/2022/06/image-31.png)
Step 8: Required categories are created with a drop-down list in Google Sheet.
![](https://ml6efdvut7qo.i.optimole.com/Sjge_4I-WIMhWGRN/w:auto/h:auto/q:auto/https://addnewskills.com/wp-content/uploads/2022/06/image-32.png)
If you update the Movie Genre category list, it will not update automatically in the drop-down list. You need to again go to data validation and Select the cell range.
How to Create Categories in Google sheets ( Summary)
We hope this tutorial on How to Create Categories in Google sheets is useful.
Related articles :
How To Import Spreadsheet Into Google Sheets ( Easy to follow Guide)
How To Bold Lines In Google Sheets ( Quick & Easy Guide )
How to Print Gridlines in Google Sheets ( Easy Guide )
How to do VLOOKUP to the left in google sheets ( Easy Guide )