Forum Discussion
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...
monica91 ,
Do I understand correctly you have empty rows all the time at the bottom of you range? To clean, select all these empty rows (from end of the range till the roe where Ctrl+End is positioned), Home->Clear-Clear All. Save and reopen workbook. As a rule Ctrl+End shall be at the end of your range after that.