K
Ken G.
Is there an easy (quick) way of deleting empty rows in a large spreadsheet?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
CLR
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
add-in called ASAP Utilities, available free from www.asap-utilities.com
Vaya con Dios,
Chuck, CABGx3
spreadsheet?Ken G. said:Is there an easy (quick) way of deleting empty rows in a large
B
bj
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.
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.
L
Leanne
Yep, hightlight the rows you want to delete, right click, press delete, then
choose one of the four options.
choose one of the four options.
J
Jim May
I sometimes use the Auto-Filter feature;
From desired column select (Blanks)
then click and highlight the Row-Selector (the column displaying the row
numbers)
of all such rows; and delete rows;
All blank records should disappear,
then unfilter;
HTH
From desired column select (Blanks)
then click and highlight the Row-Selector (the column displaying the row
numbers)
of all such rows; and delete rows;
All blank records should disappear,
then unfilter;
HTH