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...
Zonouz
Jul 13, 2022Copper Contributor
Go these simple steps:
1. Select the first empty cell
2. Press SHIFT+SPACE
3. Press CTRL+END
4. Right click on selected rows and choose Delete...
5. Save/Close and reopen to take effect [Tips]
Enjoy
1. Select the first empty cell
2. Press SHIFT+SPACE
3. Press CTRL+END
4. Right click on selected rows and choose Delete...
5. Save/Close and reopen to take effect [Tips]
Enjoy