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?
[link] [comments]
Want to read more?
Check out the full article on the original site