View Single Post
  #2   Report Post  
Paul B
 
Posts: n/a
Default

You can not delete them, you can hide them if you don't want to see the
rows, I don't think the empty rows are whats causing the large file size, a
blank workbook is only about 15kb with all the rows

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"m28leics" wrote in message
...
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!!!