Empty rows in excel

[shadyoasis]

Hello,

My spreadsheet has 1,048,263 rows. I only have data in 282 rows. How can I get rid of the other 1,047,981 rows? All the suggestions I have found online don't work. For example, I did this:

"On the Home tab, in the Editing group, click the arrow next to the Clear button, and then click Clear All.

Save the worksheet

Close the worksheet

When you open the workbook again, the last cell of the data should be the last cell on the worksheet."

But it didn't work.

Thanks.

[#2]

@shadyoasis 

Go to the first blank row below your data. Press Ctrl+Shift+End to select the blank rows. Press Ctrl+MinusSign,R,Enter to delete the selected blank rows. Press Ctrl+S to save your workbook. Press Alt,F,C to close the workbook. Press Ctrl+O to open the same workbook. Press Ctrl+End, you should now be at the bottom right cell of your data. 

[#3]

@shadyoasis 

Pictorially

To delete all the empty rows, select all the data

Execute ALT + HFDSK on your keyboard (Blank) is checked in the Paste Special dialogue box

Click OK. All the empty rows are selected

Finally, execute CTRL + -(minus sign) to delete

Shift cells up is automatically checked. Click OK

All empty rows are deleted