can a check box be used to hide / unhide rows?

Alternatively, you can keep the Filter panel open on the right and turn the "text is 'false'" filter on and off. The advantage to using the filter panel is it makes it easier to add new rows. It appears you cannot add rows to your table when a filter is on.

Another alternative, would be something like this:

Formula in B2 = AND(C$1,C2)

Fill down to complete column

The filter for column B is "Show rows containing FALSE". Or, if using the Filter panel on the right, the filter for column B is "Text is FALSE". After it is set up, hide column B

When the checkbox in C1 is checked, any row with a checked box will be hidden. When unchecked, all rows will be shown. You could put that checkbox in another table. That table would have only two cells, one cell to write "Click here to hide rows", the other being the checkbox.

If you would rather the checkbox be checked to show all rows, change the B2 formula to =AND(NOT(C$1),C2). Now the rows will be hidden when the box is unchecked and will display when the box is checked.

Yes.

You'll need a 'filter' column in which you place a formula in each of those rows telling Numbers to 'not show' the row when the box is unchecked. All other rows in the filter column must contain the text used to trigger a "show", entered in the cell, and not determined by a formula, The formula below assumes the checkbox is in cell C1

IF(C$1,"show","hide")

The filter rule is shown beside the two images of the table below. The Filter column (D) would be hidden in use.

Rows 4, 7 and 9 have the formula above.

Regards,

Barry

A quick way would be like this:

Make a column of checkboxes. Click on the little disclosure triangle in the column header (the downward facing arrow up there to the right of the B) and choose Filter Table to show rows containing FALSE.

To use the feature, put a checkmark in any rows you want to hide (such as row 3 which is hidden in this table), which makes those rows TRUE, which will hide them. When you want to show the hidden rows, click the disclosure triangle again and select TRUE (both FALSE and TRUE will be selected). When you want to hide them again, do the same thing, which will deselect TRUE.

It should work if you only have cells merged horizontally across columns. Even if the merged cells span the column you are filtering on, you can still make a filter but it may result in the filter not doing what you want for those rows. If you have any vertically merged cells, though, filters will be disabled. It sounds like you have vertically merged cells somewhere.

"…but it won't work because i have some merged cells in the table..."

That, and similar issues with sorting, is one reason for the common advice here against using merged cells.

Regards,

Barry