G
Guest
How do I eliminate all rows without any entries without having to go into
each row individually?
each row individually?
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.
A
Anne Troy
You can usually...
Select one of the columns.
Hit Edit-->Go to-->Special-->Blanks.
Then hit Edit-->Delete.
Choose Entire Row.
*******************
~Anne Troy
www.OfficeArticles.com
www.MyExpertsOnline.com
Select one of the columns.
Hit Edit-->Go to-->Special-->Blanks.
Then hit Edit-->Delete.
Choose Entire Row.
*******************
~Anne Troy
www.OfficeArticles.com
www.MyExpertsOnline.com
G
Guest
Sort first and all the blank rows will come togther.
Will
Will
D
Dave O
Sort alphabetically, which will group blank cells after filled cells.
If you need to revert back to the order the rows are currently in,
1. Insert a column and number each column;
2. Alpha sort on a column that contains blanks;
3. Delete rows that contain a row number and blanks;
4. Sort on the row number column.
If you need to revert back to the order the rows are currently in,
1. Insert a column and number each column;
2. Alpha sort on a column that contains blanks;
3. Delete rows that contain a row number and blanks;
4. Sort on the row number column.
G
Guest
Thank you but this only elimianted the line row that I had highlighted. The
alpha sort did the trick.
alpha sort did the trick.
G
Guest
Clever guy!