Filter, sort and collapse categories in Numbers
Option-Command-F toggles Numbers filters, Shift-Command-R applies sorting rules, and Command-8 or Command-9 collapses or expands selected category groups.
Numbers · Reviewed 2026-11-05 · Review method
Platform, keyboard and verification notes
- Scope
- Numbers · macOS app; Apple Mac documentation source checks on 4 November 2026 and editorial review on 5 November 2026. No running-app compatibility test is claimed.
- Keyboard and customization
- English-language Apple documentation. Modifier and punctuation keys may differ on other keyboard layouts.. Documented defaults, not a reading of your current menu. Check the app menu and custom App Shortcuts if a binding differs; focus and selected content can change its effect.
- Review basis
- Documentation reviewed 2026-11-05 by Codex — primary-documentation and editorial review; no hands-on runtime test. These bindings were not tested in a running app for this guide.
Keyboard shortcuts for this task
| Action | Keys | Context |
|---|---|---|
| Toggle filters | Option-Command-F | Enables or disables configured table filtering. Source ↗ |
| Apply sorting rules | Shift-Command-R | Uses the table’s sorting rules; inspect those rules first. Source ↗ |
| Collapse selected category groups | Command-8 | Changes visible group detail when categories are in use. Source ↗ |
| Expand selected category groups | Command-9 | Reveals the selected groups’ detail again. Source ↗ |
Choose a view operation that matches your question
A filter decides which records appear, a sort orders records, and category expansion controls the amount of visible group detail. For an expense review, you may want to filter one type of purchase, sort by a date, or collapse groups after checking them. These are separate decisions. Decide what you need to see before triggering an existing table configuration.
Review the rules before applying them
The sorting shortcut applies the sorting rules already configured for the table. It does not invent an appropriate order for your data. Likewise, toggling filters changes whether configured filtering is active. Inspect the rules and headers first, especially when a table has been prepared by someone else. A row absent from the current view may be filtered out rather than deleted.
Compare the same sample through several views
Create a small disposable table with a few dates and categories. Configure a simple sort and filter through the interface, then use the shortcuts to compare the results. If categories are in use, select an intended group and collapse or expand it. Keep track of the total structure and the visible subset separately so you can explain why an item appears to move or disappear.
Sources and corrections
- Keyboard shortcuts for Numbers on Mac — Apple Support — checked 2026-11-04
Found a mismatch? Email pashaseenainc@gmail.com with your app version, macOS version, keyboard layout and the command. Please leave personal document names out.
Keep going
Right there when you need it.
Keep a compact shortcut reference in your Mac’s menu bar.
Explore the native Mac app