a) click the colume which contains blank row you want to delete
b) ctrl+g (goto)
c) select 'special'
d) check 'blank'
e) ok
f) right click the blank row
g) select 'delete row'


"Louise" ...
Hi all

A colleague of mine has a report in Excel but somebody else has created it
and they have entered a blank line in between each row of data. As the
report is quite big, is there any way Excel will automatically remove any
blank rows without having to select them all?

Any urgent help would be appreciated.

Thank you.


Louise