Forum Discussion
over one million rows in excel sheet cannot be deleted
i am struggling to delete a million redundant rows that excel created by itself. i certainly did not create these. i am needing to add some rows to my sheet and excel tells me to delete rows because ...
No matter how many rows you delete, Excel will always have the same # of rows. All that matters is how many you use.
Perhaps there is a (hidden) object somewhere on your worksheet. If you press the F5 key and then click Special and select Objects and click OK, what happens exactly? If Excel highlights any object, pressing the Tab key will cycle through them. Maybe one is close to row 1 million?