I have an excel spreadsheet that has more than a million rows and thousands of columns (maxed out on both axis).
Whenever I delete the row at the end (1048576)it comes back.
If I delete any number of rows from the end, the exact same number of rows will come and replace the deleted rows. However, they come back with borders.
I have tried clearing (with the pink rubber icon), i have tried the inquire add in to clear excess formatting, I have restarted excel. Nothing seems to work.
Even after doing all of this clearing, if I go to the end of the file and delete any number of rows (which had everything cleared from them), the rows come back WITH borders.
Can someone please assist as I have spent more than an hour on this.
Also, before I opened the file it said that this file needed to be recovered - warning me some data might have been lost when it opened up.