Eliminating Spaces
 

How do I eliminate all rows without any entries without having to go into
each row individually?

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



"JB" wrote in message
...
How do I eliminate all rows without any entries without having to go into
each row individually?

Sort first and all the blank rows will come togther.
Will

"JB" wrote:

How do I eliminate all rows without any entries without having to go into
each row individually?

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.

Thank you but this only elimianted the line row that I had highlighted. The
alpha sort did the trick.

"Anne Troy" wrote:

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



"JB" wrote in message
...
How do I eliminate all rows without any entries without having to go into
each row individually?

Eliminating Spaces
 

Clever guy!


"Dave O" wrote:

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.