The Categories feature can make your spreadsheets easier to read and understand by instantly grouping related data points together. Organizing data into categories helps you find and focus on the information you need. You can use categories to organize student info by class, project, assignment, due date, and more.
Create a category. With a table selected, click the Organize button in the toolbar, click Categories, then use the drop‑down menu to choose the column you want to use to categorize your data. The table is reformatted automatically, with data grouped by the category you picked.
Change the category. Recategorize the same data by choosing a different column in the Categories panel, using the “Show groups for” drop‑down menu.
Hide a grouped column. In the Categories tab, click Hide Column to hide the column you chose as the category. This eliminates redundant information in the table and makes it easier to read.
Add a subcategory to further organize your data. In the Categories tab, click the Add a Category drop‑down menu to choose another column in the table. A table can have one main category and up to four subcategories.
Click the disclosure triangle in any summary row to collapse or expand a category or subcategory. This allows you to show only the data groups you want.
Turn off categories. In the Categories tab, turn off categories to ungroup the data. To make all your raw data visible, click Unhide Column under any category or subcategory where you had hidden columns.
Create a roster of students and use categories to group them into teams for an upcoming project.
Use a table to track student assessments and categorize the data by student, assignment, or marking period.
Make categories even more powerful by adding a calculation to a summary row. Numbers can perform calculations like total and average or automatically count the number of items in each column of a grouped category.
Learn more about adding calculations to category groupsShare what you learned and help others discover the Apple Teacher Program.
A link to this page in the Apple Education Community has been copied to your clipboard.