| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to delete empty rows in multiple column?
Hi guys, How to delete empty rows in multiple column? Here's the example of the data.. PSW101 PSW102 PSW202 PSW201 PSW301 PSW302 0 0 0 1 0 0 2 0 0 0 0 0 1 0 0 0 -- x15 ------------------------------------------------------------------------ x15's Profile: http://www.excelforum.com/member.php...o&userid=29510 View this thread: http://www.excelforum.com/showthread...hreadid=492120 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to delete empty rows in multiple column?
I see no empty rows ? but rows with a 0
Start here http://www.rondebruin.nl/delete.htm -- Regards Ron de Bruin http://www.rondebruin.nl "x15" wrote in message ... Hi guys, How to delete empty rows in multiple column? Here's the example of the data.. PSW101 PSW102 PSW202 PSW201 PSW301 PSW302 0 0 0 1 0 0 2 0 0 0 0 0 1 0 0 0 -- x15 ------------------------------------------------------------------------ x15's Profile: http://www.excelforum.com/member.php...o&userid=29510 View this thread: http://www.excelforum.com/showthread...hreadid=492120 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to delete empty rows in multiple column?
x15 Wrote: Hi guys, How to delete empty rows in multiple column? Here's the example of the data.. Pls see attachment for the sample. Thanks & have a nice day :) -- x15 ------------------------------------------------------------------------ x15's Profile: http://www.excelforum.com/member.php...o&userid=29510 View this thread: http://www.excelforum.com/showthread...hreadid=492120 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to delete empty rows in multiple column?
Not sure what defines an empty row:
Absolutely no entries in any cell (including 0's) or If only numeric values in cells and you don't want any rows adding to 0 There are many ways to do this - but you need to first carefully define what excel needs to find in order to keep a row - or what it needs to find to delete a row. You can cycle through all rows (bottom up) and check each row & decide. You can create a dummy column with a simple formula that equates to some value. Copy/Paste Values on this column. Do a replace all on the value you don't want (replace with nothing entered in the replace with. Edit GoTo Special Blank Cells Delete rows Or you can get more creative... -- steveB Remove "AYN" from email to respond "x15" wrote in message ... x15 Wrote: Hi guys, How to delete empty rows in multiple column? Here's the example of the data.. Pls see attachment for the sample. Thanks & have a nice day :) -- x15 ------------------------------------------------------------------------ x15's Profile: http://www.excelforum.com/member.php...o&userid=29510 View this thread: http://www.excelforum.com/showthread...hreadid=492120 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hpw do I delete multiple empty rows found between filled rows? | Excel Worksheet Functions | |||
| How to Delete empty rows in excel in b/w rows with values | Excel Worksheet Functions | |||
| Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
| Delete empty rows | Excel Programming | |||
| Delete empty rows. | Excel Programming | |||
Linear Mode
