Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DELETE ALL ROWS & COLUMNS WITH ZERO BALACES
I basically would like to know how do I delete a range of cells with zero
balances. In the worksheet, these balances do not fall under each other but they are spead out. I would like for all the information in the row to be deleted. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DELETE ALL ROWS & COLUMNS WITH ZERO BALACES
First use filter to show only these rows which zero balance.
(Data/Filter/Auto Filter...) Then delete all the filteretd rows (zero balance) and then show all data again(Data/Filter/Show All) -- Best regards, --- Yongjun CHEN ================================= XLDataSoft - Data Analysis Expert, Excel/VBA Specialist - - - - www.XLDataSoft.com - - - - Free Excel-Based Data Processing Tool is Available for Download Free Excel / VBA Training Materials is Available for Download ================================= "nads" wrote in message ... I basically would like to know how do I delete a range of cells with zero balances. In the worksheet, these balances do not fall under each other but they are spead out. I would like for all the information in the row to be deleted. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I delete blank rows from excel without selecting them? | Excel Worksheet Functions | |||
easy way to delete all rows with no text in them? | New Users to Excel | |||
convert columns to rows & rows to columns | Excel Discussion (Misc queries) | |||
How to swap rows and columns? | Excel Discussion (Misc queries) | |||
How to keep rows together when sorting columns? | Excel Worksheet Functions |