# Category Tags in Google Sheets

**URL:** <https://community.tiller.com/t/category-tags-in-google-sheets/1144>\
**Category:** Google Sheets\
**Tags:** google-sheets, troubleshooting, tracking\
**Created:** [November 13, 2019, 12:44pm UTC](https://community.tiller.com/t/category-tags-in-google-sheets/1144 "2019-11-13T12:44:58Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![patmrogers](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/patmrogers/32/571_2.png) [@patmrogers](https://community.tiller.com/u/patmrogers)\
**Post date:** [November 13, 2019, 12:44pm UTC](https://community.tiller.com/t/category-tags-in-google-sheets/1144/1 "2019-11-13T12:44:58Z")

</div>

For some reason my category tag drop-down in Google Sheets is not loading for new transactions. Any help with this?

---

<div class="post-metadata">

**Author:** ![jono](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/jono/32/283_2.png) [@jono](https://community.tiller.com/u/jono)\
**Post date:** [November 13, 2019, 10:13pm UTC](https://community.tiller.com/t/category-tags-in-google-sheets/1144/2 "2019-11-13T22:13:14Z")

</div>

Hi @patmrogers,  
Are you referring to the dropdown options for the Category or Tags columns in your Transactions sheet?

If the dropdowns don’t appear in the Category column, you can add them to the entire column by selecting all the rows in the Category column except the top header row and adding the Data validation to `List from a range`: `Categories!A2:A`

I’m not aware that there was a dropdown for the Tags column, but you could add one by selecting all the cells except the top one in the Tags column. Then add the Data validation:  
`List from a range`:` 'Tags Report'!A9:A`