we are not trying to hide cells we would like to delete it all the way just
keep the subtotatals?
also please advise how subtotals will work?

"RJ" wrote:

It sounds like you should set up subtotals on the workbook. Then you can move
up and down based on the amount of detail you need. The subtotals and
grandtotals will remain in the same cells even when you hide the detail by
moving to a more general level. To put subtotals on, select the range of data
and then go to Data -- Subtotals.

"dk" wrote:

How can we delete rows but the total balance shall still remain ex: we have a
customer that has 10 bills and we want to make a invoice with his total
balance without having the rows of description and dates etc.? or exampled
how we much we earned this month without after deleting detailed info. we
have alot of workbook linked to the totals but doesn't need the detailed items