Forum Discussion
monica91
Apr 23, 2019Copper Contributor
My excel sheet keeps recreating rows after I delete them
I am working on a task that requires a separate workbooks. In my second workbook there is an extra 100+ rows that I keep deleting and they are reappearing. I have tried to choose CTRL+End and the pre...
PeterBartholomew1
Apr 23, 2019Silver Contributor
100 rows of … , what exactly?
The sheet will always have 1048576 rows, so any rows you delete will be replaced by blank rows.
These will reflect any whole column formatting that might be in play.