#1   Report Post  
Ken G.
 
Posts: n/a
Default Deleteing empty rows

Is there an easy (quick) way of deleting empty rows in a large spreadsheet?
  #2   Report Post  
CLR
 
Posts: n/a
Default

This can be accomplished easily with one of the standard features of the
add-in called ASAP Utilities, available free from www.asap-utilities.com

Vaya con Dios,
Chuck, CABGx3


"Ken G." wrote in message
...
Is there an easy (quick) way of deleting empty rows in a large

spreadsheet?


  #3   Report Post  
bj
 
Posts: n/a
Default

one of the easiest is not really deleteing.
If there is a column which will have data for any non empty row.
select everything and sort by that column.
Note there may be "" values beow the last row. If you do want these deleted
select the rows beloow the last set of data you want to keep ad edit delete
rows.

"Ken G." wrote:

Is there an easy (quick) way of deleting empty rows in a large spreadsheet?

  #4   Report Post  
Leanne
 
Posts: n/a
Default

Yep, hightlight the rows you want to delete, right click, press delete, then
choose one of the four options.


"Ken G." wrote:

Is there an easy (quick) way of deleting empty rows in a large spreadsheet?

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
Pivot Tables: How do I show ALL field rows, including empty rows?? [email protected] Excel Worksheet Functions 2 April 8th 05 06:21 PM
Can Excel "slide up" rows with content thru empty rows to condense portly44 Excel Worksheet Functions 2 April 1st 05 12:47 AM
delete empty rows between rows with text Paulo Baptista Excel Discussion (Misc queries) 2 February 28th 05 03:41 PM
empty rows at bottom of worksheet michael g Excel Discussion (Misc queries) 2 January 18th 05 09:17 PM
Remove empty rows in excel? Clbmgr Excel Discussion (Misc queries) 6 December 2nd 04 02:02 AM


All times are GMT +1. The time now is 04:59 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"