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!!!

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!!!

Hi m28leics,

See Debra Dalgeish's notes and solutions:

http://www.contextures.com/xlfaqApp.html#Unused


---
Regards,
Norman



"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!!!