How to stop rows underneath being affected by a filter [Closed]

Report
-
Posts
2758
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 17, 2021
-
Hello, I have a filter set up for a table which works fine and is filtered when a quantity is entered in column D. However under the table is more rows with the subtotal and grand total in, obviously you dont need to enter anything in this. But whe i filter out the blanks those rows disappear? how i do i stop this please? I have tried everything and desperate for help! Thank you



1 reply

Posts
2758
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 17, 2021
462
Hi Jane,

Instead of applying filter, try creating a table (Insert > Table) for your data without the last row.

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!