MacMost Q&A Forum • View All Forum QuestionsAsk a Question

How Do I Conditionally Hide Rows In Numbers?

Is there a way to conditionally hide a row? I want to hide rows based on an answer in a cell in its row. I have a client list but want to hide the ones that are not active. So if o2 = ‘yes’ then I want row 2 to be hidden, and if o3 = ‘no’ or blank then I want it shown…

I want to keep the information in the remaining cells (last contact, what type of client, etc) for future follow up and info but it doesn’t need to be seen on a daily basis.

Comments: One Response to “How Do I Conditionally Hide Rows In Numbers?”

    1 year ago

    Yes. Use filters. Simply filter the table based on the value of that column. I talk about filters in yesterday's tutorial:

Comments Closed.