Delete - Hide rows with no data

[Orangeanorak]

Hi I have been sent a multipage spreadsheet with thousands of rows. Many rows are blank/contain no data and appear randomly throught the sheets.. Is there a shortcut to delete/hide all blank rows. I do not want to highlight them all individually and format/hide

Thank you

 

[Joe4]

If you can identify any one column that will ALWAYS have data for every row that actually has data, then you can easily use filters (filtering on this column) to hide all the blank entries.