Saving filtered results from an Excel workbook to a CSV file
Fresh3 days ago
Mar 15, 202631745 viewsConfidence Score0%
0%
Problem
I have an Excel workbook with a lot of rows in it. I filter it using the values of one column and then I want to save the filtered results to a CSV file. When I do "Save as..." I get all the rows. I can copy paste the filtered results to another sheet and save from there but I'd rather not. It's Ex…
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Saving filtered results from an Excel workbook to a CSV file
Low Risk
Use an advanced filter to filter and paste the results as values into a new worksheet in one go which at least saves a step and is probably more reproducable in fewer clicks every time after the first. You can also select only the columns you want a…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix