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 i have hit the limit of rows permitted by the program.
i say again - i did not create over a million rows. it seems to have done this by itself.
if i select a large number of rows, right click and delete, it 'appears' to be doing 'something' that 'seems' to 'appear' as if 'maybe' it has deleted rows, but it in fact has not.
there are still over a million rows in my spreadsheet, i want to remove all but 100 of them so i can carry on with my work.
this is just insane.\
i would also like to take this opportunity to point out that the way microsoft forces us to now permit their ai systems to scrape our computers just to have the opportunity to try and get support help is disgusting and likely violates numerous privacy laws. you literally must permit microsoft access to ALL your personal data just to post a support help question here, and while copilot is impossible to turn off in excel, it can be turned off in word and outlook, but doing so removes the capability of contacting help or even reading/accessing support help files.
this is madness and must stop.
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?
Ensure there are no unintended formats or content in very far-down cells, as this can sometimes trick Excel into believing there's data present. Be cautious with copying and pasting large datasets, as it can sometimes inadvertently lead to large unwanted ranges.
If issues persist and if the current workbook continues to behave unexpectedly, sometimes starting with a new workbook and copying only the necessary data over can be less cumbersome.
