-1

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.

Improve this question
6
  • 2
    when you delete a row, only data in that row is deleted and data below deleted row is shifted up. Number of rows/columns in sheet will remain same. However, when you save file, only rows with data or formatting are saved. Empty rows with default formatting are not saved (to keep file size small). In your case default formatting seems to be cell with border. – Sandeep Aug 3 '18 at 13:42
  • you cant remove the rows/columns just hide them – PeterH Aug 3 '18 at 13:54
  • @Sandeep Thanks for your reply, How do I change this setting? – AhsinSharif Aug 3 '18 at 14:06
  • Cell border you see in ms excel are not visible while printing unless you set borders from settings. Add a new sheet and try to see print preview (Ctrl + P). If you see borders around empty cells, then you need to edit default template with formatting and settings you need. – Sandeep Aug 3 '18 at 14:16
  • Are you sure those are actually borders and not gridlines? support.office.com/en-us/article/… – Máté Juhász Aug 3 '18 at 14:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.