Saving filtered results from an Excel workbook to a CSV file

Saving filtered results from an Excel workbook to a CSV file 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 Excel 2003 primarily.
Asked by: Guest \| Views: 308

Total answers/comments: 1

Comments display order:

Guest [Entry]

Use a pivot table. Click on any location in your table, Click Insert, select Pivot Table, then set up the columns you want to keep. You can filter a Pivot table then save as CSV or text (tab delimited). It saves only the filtered pivot table.