Creating a Glossary in Excel - separating categories into tabs

River Davies 0 Reputation points
2026-07-21T10:31:13.2833333+00:00

Hello!

I am currently trying to create a glossary for my sign language class. This involves having a variety of headings including categories and subcategories depending on how the word is relevant (e.g. art, sport, history etc).

I am wanting one main tab with all the terms and a tab for each category to clearly outline them. HOWEVER, I would like to be able to edit the term no matter what tab I'm in and for them to update everywhere, rather than having to manually update it in every single tab.

Any advice?

Microsoft 365 and Office | Excel | For education | MacOS
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. JUNIOR SIPILANYAMBE 115 Reputation points
    2026-07-21T10:34:43.3133333+00:00

    Instead of duplicating the data across worksheets, keep one master table with all your terms and categories. Then use FILTER (or a PivotTable/Power Query if needed) on each category tab to display only the relevant entries. That way, you only edit the master list, and every category tab updates automatically.

    Was this answer helpful?

    1 person found this answer helpful.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.