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