How to stop rows underneath being affected by a filter

Closed
Jane - Jun 23, 2016 at 09:25 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 27, 2016 at 10:15 AM
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



Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jun 27, 2016 at 10:15 AM
Hi Jane,

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

Best regards,
Trowa