Excel formula required

Percybridge

I am transferring data from one excel sheet to various sheets.
When I go into the individual sheets therefore, there are lots of blank rows.
Does anyone have a formula for getting rid of blank unused rows.
Thank you.

PhilCo_2

Do ctrl+g to get the Go To box up. Click on Special and select Blanks and okay. This will highlight all blanks, do delete and select Entire row.

Percybridge

I did that and the entire row was deleted.
I do not think I have explained it properly.
Some rows have information on them, but not in every column.
I want to keep that row, but I want to delete the rows that have nothing on them.
Can I do this?

PhilCo_2

have a column that does a count of all the other columns then filter out the rows that are 0 and delete.

superjaggybunnet

Highlight the rows with nothing in them and press 'Ctrl -' to delete them.