View Single Post
  #1   Report Post  
m28leics
 
Posts: n/a
Default How do I remove blank rows in Excel?

I am using Excel which came in Office XP bundle. I'm sure it's a really dumb
question, but how do I completely remove empty rows from a sheet. I have a
sheet with 60 rows that contain data, but is has over 65,000 rows with no
data that I'm not sure how to delete.
I've tried highlighting and deleting them, but it just clears any data in
them, so I'm stuck with a sheet thats about 2mb instead of a few Kb.
Help!!!