MacMost Now 680: Filtering Rows and Columns in Numbers
You can hide rows and columns in Numbers to effectively filter your data. Hiding can be done one row or column at a time, or by groups of rows and columns. You can also set criteria for rows or columns to be automatically filtered, allowing you to see only the data you need.
Want to know more about how to use Numbers on your Mac? Check out this MacMost course!
Related Subjects: iWork (42 videos), Numbers (185 videos)
Related Video Tutorials:
No related posts.
Comments: 3 Responses to “MacMost Now 680: Filtering Rows and Columns in Numbers”
Gill
11 years ago
Hi Gary
Finding your videos the best! A great find.
Is there any way of getting the total to reflect only the total of the filtered info?
Either when hiding rows or using categories.
I want to filter out figures for a particular tax year (which I can do) but can't figure out how to get a total for only that info. ie. the grand total still shows as illustrated in your tutorial. Is this the only option?
Thanks
Hi Gary
Finding your videos the best! A great find.
Is there any way of getting the total to reflect only the total of the filtered info?
Either when hiding rows or using categories.
I want to filter out figures for a particular tax year (which I can do) but can't figure out how to get a total for only that info. ie. the grand total still shows as illustrated in your tutorial. Is this the only option?
Thanks
I don't think filtering is what you want. You want to perform a calculation. So a formula is what you want. Start by checking out the SUMIFS function.
Perfect, just what I needed to know. Thank you!