Drop Down Filtering Option For Numbers On MacOS 10.12.3

Question

Drop Down Filtering Option For Numbers On MacOS 10.12.3

I've worked with Excel in various versions for several years and have only recently gotten to dig deeper with the functionality in Numbers on my iMac running MacOS Sierra 10.12.3 and the most recent version of Numbers. One functionality that I've yet to find in Numbers is the ability to easily filter and remove a filter with a simple drop down option for the columns like what is shown in the below screen shot from Excel. Is this possible with Numbers?

iMac, macOS Sierra (10.12.3)

Posted on Mar 18, 2017 2:18 PM

Reply

Answer 1

Top-ranking reply

SGIII

Level 8

37,550 points

Mar 18, 2017 6:08 PM in response to andreafromlutz

Yes, it's there. Go up to the column Letter and activate the drop-down via the 'v' in the right part of the cell.

And you would do more complex filters via the panel at the right.

SG

Reply

Answer 2

SGIII

Level 8

37,550 points

Mar 19, 2017 5:28 AM in response to andreafromlutz

Glad you've got it working. Note that in Excel you check or uncheck a box to include or exclude a value in the filter. In Numbers you simply select the value to include it. Then to exclude it (the Excel equivalent of unchecking the box) you simple select it again.

Thanks for the green tick!

SG

Reply

Answer 3

Mar 18, 2017 6:08 PM in response to SGIII

That is exactly what I was looking for SG!! Your response and assistance is very much appreciated!!

Reply