Hi Edgar,

Example:

Do the following:

1. Click the first row the Excel sheet.
2. On the Data manu, point to Filter, and then click the AutoFilter.
3. All blank rows will be displayed along with the data.
4. Click the row buton on the left and highlight the rows you wna to delete.
5. Right-click and click Delete.

Challa Prabhu



"Edgar" wrote:

I pasted a large document from Word into Excel. Everything worked perfectly
but now I need to remove the blank lines that became empty rows. I suspect a
macro would accomplish this but I have never programmed a macro in Excel.
--
-Edgar