DELETE ALL ROWS & COLUMNS WITH ZERO BALACES

[Guest]

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.

 

[Daniel CHEN]

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
=================================