Let's say that you have a worksheet...and then you take the worksheet and put data in column 1 and then you drag that data down so that it autofills a bunch of cells...let's say all the way to row...ummmm....8,000.
OK...NOW, you delete or clear out all the data in rows 11-8,000....so now all you have left is 9 cells worth of data. BUT...Excel still seems to treat this worksheet as if it has 8,000 rows of data. If you try to scroll down the page using the scroll arrows, it will take you forever to reach the bottom...PLUS, the size of your file is HUGE.
So...how do you get Excel to forget that there was ever data in rows 11-8,000. I know this has to be simple. Thanks.
OK...NOW, you delete or clear out all the data in rows 11-8,000....so now all you have left is 9 cells worth of data. BUT...Excel still seems to treat this worksheet as if it has 8,000 rows of data. If you try to scroll down the page using the scroll arrows, it will take you forever to reach the bottom...PLUS, the size of your file is HUGE.
So...how do you get Excel to forget that there was ever data in rows 11-8,000. I know this has to be simple. Thanks.