Deleting Rows With Subtotals

Topic

New Reply

Is there a quick and easy way to delete all rows that contain subtotal formulas?
Thanks in advance.

Reply | Quote

Replies

How do you define a row as being a subtotal row?

cheers, Paul

Reply | Quote

How do you define a row as being a subtotal row?

cheers, Paul

If it has a subtotal formula (i. e., “=subtotal(x,y)”)

Reply | Quote

If it has a subtotal formula (i. e., “=subtotal(x,y)”)

I am assuming that you do not want the subtotal rows
simply click on Data on the menu bar
select Subtotals
click on Remove All

This will remove all subtotals and grand total.

Reply | Quote

I am assuming that you do not want the subtotal rows
simply click on Data on the menu bar
select Subtotals
click on Remove All

This will remove all subtotals and grand total.

Thanks.

Reply | Quote