DELETING SUBTOTALS FROM A COLOMN

W

William

I have a column with about 7000 rows. Many of these rows are subtotals,
summing 2-10 rows each. I'd like to delete all the subtotal rows all at
once. I tried creating an outline, and selecting outline level one creates a
view of the subtotals, but selecting the subtotals and deleting from this
view just deletes all the hidden rows as well. There must be another way?

Thanks for ideas
 
B

Bob I

After numbering a helper row (so you can put the sheet back in the order
it was in) sort on the column with "sum" in it and then delete the "sum"
rows. Then Sort on the helper column to put things back in order.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating subtotals 22
Copying from Subtotal Data 2
Extremely slow subtotals in Excel 2003 3
Presenting Subtotals only 2
Subtotals Deleting Rows after removing Subtotal - 2003 Excel 1
unprotect subtotals 1
Error in Subtotal Wizard (Grouping and Outlining) 3
How do I subtotal specific / random rows from a spreadsheet? 1

Top