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.