How to delete rows not in filter
Problem
I have a very large table in Excel (1000's of rows) and I filter it to only show 10 rows. I wonder if there is a way to delete the rows not shown (i.e. don't meet filter conditions)? This would enable me to reduce the file size before I send it. There are many thousands of rows down under the table the user has created complex formulas and graphs which wont carry if I copy across to another worksheet if I just copy the rows.
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Fix for: How to delete rows not in filter
Try this way for a quick solution:- Copy the filtered 10 results into another sheet Delete the actual sheet EDIT: As per the update, below are the steps:- Before starting, take a backup copy of excel sheet Assuming you are filtered all the records and showing only 10 Rows Remaining 1000's are hidden Click on Office Button Click on Prepare option Click on Inspect Document Refer this screenshot, how it looks Click on Inspect button You will see a option "Hidden Rows and Columns" with "Remove All"…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix