Hello,
I routinely import a list of calls into Excel to analyze. The list is usually 350k rows or more. Many of the rows are blank or junk so I filter and delete them. That reduces the number of rows to about 75k.
What I don't understand is that Excel still thinks that my range or list is 350k rows deep. When I hit Ctrl+End it goes all the way down to row 350k even though the range is blank from row 75k and down. This makes the file size extremely large and makes any filtering, sorting or analysis very, very time consuming.
Is there a way to get Excel to not include all these blank rows in what it thinks is the working range? Can I compress the file somehow to remove the "blank" rows?
Thanks,
Jason
I routinely import a list of calls into Excel to analyze. The list is usually 350k rows or more. Many of the rows are blank or junk so I filter and delete them. That reduces the number of rows to about 75k.
What I don't understand is that Excel still thinks that my range or list is 350k rows deep. When I hit Ctrl+End it goes all the way down to row 350k even though the range is blank from row 75k and down. This makes the file size extremely large and makes any filtering, sorting or analysis very, very time consuming.
Is there a way to get Excel to not include all these blank rows in what it thinks is the working range? Can I compress the file somehow to remove the "blank" rows?
Thanks,
Jason
