Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Deleteing empty rows
Is there an easy (quick) way of deleting empty rows in a large spreadsheet?
|
#2
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Tables: How do I show ALL field rows, including empty rows?? | Excel Worksheet Functions | |||
Can Excel "slide up" rows with content thru empty rows to condense | Excel Worksheet Functions | |||
delete empty rows between rows with text | Excel Discussion (Misc queries) | |||
empty rows at bottom of worksheet | Excel Discussion (Misc queries) | |||
Remove empty rows in excel? | Excel Discussion (Misc queries) |