| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003, how can I delete all empty rows
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003, how can I delete all empty rows
One way if they are truly blank, select the range, press F5, select special,
select blanks, press OK. Do editdelete or press ctrl + -, select entire row and press OK Regards, Peo Sjoblom "Edgar" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003, how can I delete all empty rows
Thanks for the help!
-- -Edgar "Peo Sjoblom" wrote: One way if they are truly blank, select the range, press F5, select special, select blanks, press OK. Do editdelete or press ctrl + -, select entire row and press OK Regards, Peo Sjoblom "Edgar" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003, how can I delete all empty rows
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003, how can I delete all empty rows
Thank you for the reply!
-- -Edgar "challa prabhu" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
| how do i find and delete all empty rows in an excel worksheet | Excel Worksheet Functions | |||
| Delete empty rows from print in Excel | Excel Worksheet Functions | |||
| [excel 2003] Delete empty rows | Excel Worksheet Functions | |||
| how do i delete empty rows in excel? | Excel Discussion (Misc queries) | |||
![Edgar[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
