Forum Discussion
Empty rows in excel
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: "...
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