ExcelBanter - additional lines from filters

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - additional lines from filters (https://www.excelbanter.com/excel-discussion-misc-queries/140344-additional-lines-filters.html)

Bleys444

additional lines from filters

I recently copied some data from a tab containing filters. When I pasted the
values material, the file size of the new sheet was over 20 megs. I think it
was because thousands of additional lines were added. Is there a way to
remove excess lines without data?

All times are GMT +1. The time now is 08:21 AM.