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

How Do I Make All Tables In a Single Sheet Move When Filters Are Turned On?

I have a sheet in Numbers that I utilize as a database. When I filter rows, I want all the tables to move with the table that was filtered. Otherwise, when I filter and then print there are tables that are way lower in my spreadsheet than I want.
—–
Tim Sherrod

Comments: One Response to “How Do I Make All Tables In a Single Sheet Move When Filters Are Turned On?”

    2 months ago

    If the tables aren’t snapping automatically to readjust, then I don’t think there is a way to force it to do that.

    You could just move the other tables. Should only take a few seconds and then you can Undo after printing. How many times do you need to print? Shouldn’t add that much work.

    Or, you could arrange the tables so there is nothing underneath the one that is being filtered. That is how you would usually handle a table that contains records and will grow over time anyway. You could put the other tables above it or to the sides.

Leave a New Comment Related to "How Do I Make All Tables In a Single Sheet Move When Filters Are Turned On?"

:
:
:
0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)