Forum Discussion
Delete Millian blank rows in Excel 2016
Dears, I want to delete the million blank rows in one sheet in my excel file to control the size of the file. I have tried to clear all and delete these rows, then save and reope...
Click Ctrl+End, you will be at the end of your former range. Select all rows from your data end till that place, After that on ribbon Home->Clear-Clear All (that icon is on the right site of the ribbon).
Save your file (or reopen with saving). Click Ctrl+End again to check if helped.