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
MacMost Q&A Forum • View All Forum Questions • Ask a Question
How Do I Make All Tables In a Single Sheet Move When Filters Are Turned On?
Comments: One Response to “How Do I Make All Tables In a Single Sheet Move When Filters Are Turned On?”
Comments Closed.
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.