| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
DELETING SUBTOTALS FROM A COLOMN
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 -- William |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Label colomn with the headers | Excel Worksheet Functions | |||
| Subtotals Deleting Rows after removing Subtotal - 2003 Excel | Excel Worksheet Functions | |||
| deleting rows in a huge spreadsheet with subtotals | Excel Discussion (Misc queries) | |||
| colomn to row | Excel Discussion (Misc queries) | |||
| sum of colomn.. | Excel Discussion (Misc queries) | |||
Threaded Mode
