1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Is it possible to add "categories" to an Excel table?

Hello, everyone.

I have a lot of books at home and I have a table in an Excel spreadsheet which I use to sort them out, my question is:

I there a way for me to add multiple selectable categories to this table?

What I mean is: I have a column called "genre/subject" with simple categories for me, such as "Poetry" or "Essays", however I have some books which contain both poetry and essays, if I simply put "Poetry/Essays" in the column instead of making it part of both "Poetry" and "Essays" it'll create a third "Poetry/Essays" category, is there a way for me to make the categories selectable so that I can apply multiple categories to the same book in this table?

Thank you all for your help, I'm not great at Excel.

Edit: I'm not sure which version I have, I think it's Office 2021? Is this a valid option?

submitted by /u/Rexxzn
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#rows.com
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#financial modeling with spreadsheets
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#AI-powered spreadsheet
#spreadsheet API integration
#Excel
#Categories