The spreadsheet is about 10000 rows. I created a subtotal function, then collapsed the spreadsheet to show only the level “2” items. Inserted a blank column and entered a formula. I inadvertently copied it to the bottom of the spreadsheet instead of to the bottom of the data area (1000 0 rows). No problem — just delete the formula from from cells in rows 10000 to 65000… Oops — that’s not sufficient. When I try to un-collapse the subtotals, Excel issues an error message that it “cannot shift objects off sheet”. When I press Ctrl-End, the cursor goes all the way to row 65000+
I tried to select all the rows below 10000, but Excel became unresponsive, and I had to shut it down using Task Manager. It appears to be impractical to select and delete more than about 100~200 rows at a time before Excel becomes unresponsive.
Is there an easy way to delete all the rows between 10000 and 65000?
