How do I remove blank rows in Excel?

G

Guest

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

Paul B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot remove empty rows 8
Deleting rows in Excel 2007 using filters 1
Deleting Multiple Blank Rows 6
How to filter rows data based on background color of individual cells 1
How to have more than 65,000 rows in excel 2007 3
Deleting blank rows with formulas in them 7
how do i remove unshaded rows from Excel? 3
Deleting/removing unused rows in a worksheet 3

Top