How to remove filter on Numbers

I filtered a numbers sheet by a value. Now I am not being able to return to the sheet. Stuck with the filtered result page!!!

Posted on Feb 18, 2022 8:24 PM

Top-ranking reply

Yellowbox

Level 7

21,915 points

Posted on Feb 18, 2022 11:24 PM

Hi sridharR1761,

Click anywhere on the table to make it active.

Organise button > Filter tab > Filters turn off the filter.

Regards,

Ian.

View in context

Similar questions

Numbers Quick Filter not working In one of my spreadsheets, I did a quick filter on a column that has text in some of the rows. I need to quickly hide all the rows without values, in order to do some calculations with only the rows that have values in this column. So... I selected the column, quick filter, deselected BLANK and left the rest of the values checked. I should have ended up with about 60 rows. The result was only a few rows. Most of the rows that should have been selected, they were hidden. I used to have Excel (Windows platform)... super easy/intuitive/quick. So I'm familiar with the whole concept. Does Numbers - Quick Filter - work? If so, what are the steps to 'quick filter' a column?
2164 5
Numbers v5.1 missing rows unhide greyed out I'm using Numbers V 5.1, and a multi-sheet workbook that I've been using for years, has on one of the sheets, the first 20 rows which will not display. Under Table, the 'Unhide Rows' option is greyed out. I read that someone said that filters might affect this option, but there are no filters on this sheet. Can anyone help?
1034 6
Cannot allow filtering in Numbers? I want to filter a list of purchases to show only certain items. Numbers will not let me turn on filtering? Is there something I need to do first? To the right of the spreadsheet, if Filter is highlighted, I cannot switch the Filters toggle to on, and in the Organize menu, "Turn filters on" is grayed out. Thanks for any suggestions.
1338 4

1 reply