Jan 17 2019 09:14 PM
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 reopen. it isn't work. the vertical scroll bar still shows these are million rows.
please advice how to deal with it.
Jan 17 2019 11:27 PM
Jan 18 2019 03:28 AM
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.