Deleteing empty rows
Is there an easy (quick) way of deleting empty rows in a large spreadsheet?
|
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? |
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? |
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? |
All times are GMT +1. The time now is 08:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com