Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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!!!
  #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!!!



  #3   Report Post  
Norman Jones
 
Posts: n/a
Default

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with Charting My Data -- DavidM Charts and Charting in Excel 7 January 7th 05 02:08 PM
Creating GIFs in Excel 2003 for use in Dreamweaver Lou Crandall Charts and Charting in Excel 2 January 2nd 05 08:58 PM
How do I shade alternate rows in Excel 2002? drummergirl73 Excel Discussion (Misc queries) 2 November 29th 04 10:17 PM
How to remove an Excel Main Menu item inserted by .xla file Dennis Excel Discussion (Misc queries) 5 November 28th 04 09:39 PM
No Smart Tag help: just a blank "MS Excel Help" window - Excel 2003 Ian Ripsher Excel Discussion (Misc queries) 0 November 26th 04 09:43 PM


All times are GMT +1. The time now is 10:19 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"