Is there any easy way to delete blank rows in excel

[AccruedExpenditure]

Is there any easy way to delete blank rows in excel instead of deleting each one manually?

 

[bonkers325]

filter out blank rows, then delete them. use the autofilter

 

[Alkesh]

highlight them on the sidebar and delete them all.

 

[NikPreviousAcct]

http://forums.anandtech.com/categories.aspx?catid=33&flcache=8975181&entercat=y

 

[Xyclone]

Originally posted by: Alkesh
highlight them on the sidebar and delete them all.

 

[blurredvision]

Originally posted by: Nik
http://forums.anandtech.com/categories.aspx?catid=33&flcache=8975181&entercat=y

Hey, alright. Way to link to the software forum AFTER the question has been answered. You are so helpful.

 

[NikPreviousAcct]

Originally posted by: blurredvision

Originally posted by: Nik
http://forums.anandtech.com/categories.aspx?catid=33&flcache=8975181&entercat=y

Hey, alright. Way to link to the software forum AFTER the question has been answered. You are so helpful.

I made my point, didn't I?