| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removeing the Grand Total Line when subtotals are removed
I have Excel 2003. I have a spreadsheet that I have run subtotals on.
However, when I do Remove All to remove the subtotals the grand total and the +- bar is still there. How can I get rid of all the totals in the spreadsheet including the grand total and the +- bar on the left? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Removeing the Grand Total Line when subtotals are removed
I'd try removing those subtotals once more.
Make sure you select the entire range before you do it, though. Melody wrote: I have Excel 2003. I have a spreadsheet that I have run subtotals on. However, when I do Remove All to remove the subtotals the grand total and the +- bar is still there. How can I get rid of all the totals in the spreadsheet including the grand total and the +- bar on the left? Thanks -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Removeing the Grand Total Line when subtotals are removed
That worked. Got any idea how I can write that into a macro. I have the
remove all in the macro, just need to know how to make it select the whole range to include the grand total line. Thanks for your help. "Dave Peterson" wrote: I'd try removing those subtotals once more. Make sure you select the entire range before you do it, though. Melody wrote: I have Excel 2003. I have a spreadsheet that I have run subtotals on. However, when I do Remove All to remove the subtotals the grand total and the +- bar is still there. How can I get rid of all the totals in the spreadsheet including the grand total and the +- bar on the left? Thanks -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Removeing the Grand Total Line when subtotals are removed
Can you cheat and just use all the cells in the worksheet?
Worksheets("sheet1").Cells.RemoveSubtotal Melody wrote: That worked. Got any idea how I can write that into a macro. I have the remove all in the macro, just need to know how to make it select the whole range to include the grand total line. Thanks for your help. "Dave Peterson" wrote: I'd try removing those subtotals once more. Make sure you select the entire range before you do it, though. Melody wrote: I have Excel 2003. I have a spreadsheet that I have run subtotals on. However, when I do Remove All to remove the subtotals the grand total and the +- bar is still there. How can I get rid of all the totals in the spreadsheet including the grand total and the +- bar on the left? Thanks -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
THANKS! Removeing the Grand Total Line when subtotals are removed
That didn't quite work, but this did. THANKS! These little things can be so
frustrating sometimes. Especially when you don't work with it daily. Worksheets(1).Cells.RemoveSubtotal "Dave Peterson" wrote: Can you cheat and just use all the cells in the worksheet? Worksheets("sheet1").Cells.RemoveSubtotal Melody wrote: That worked. Got any idea how I can write that into a macro. I have the remove all in the macro, just need to know how to make it select the whole range to include the grand total line. Thanks for your help. "Dave Peterson" wrote: I'd try removing those subtotals once more. Make sure you select the entire range before you do it, though. Melody wrote: I have Excel 2003. I have a spreadsheet that I have run subtotals on. However, when I do Remove All to remove the subtotals the grand total and the +- bar is still there. How can I get rid of all the totals in the spreadsheet including the grand total and the +- bar on the left? Thanks -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
THANKS! Removeing the Grand Total Line when subtotals are removed
I like to use the name of the sheet if I know it.
Melody wrote: That didn't quite work, but this did. THANKS! These little things can be so frustrating sometimes. Especially when you don't work with it daily. Worksheets(1).Cells.RemoveSubtotal "Dave Peterson" wrote: Can you cheat and just use all the cells in the worksheet? Worksheets("sheet1").Cells.RemoveSubtotal Melody wrote: That worked. Got any idea how I can write that into a macro. I have the remove all in the macro, just need to know how to make it select the whole range to include the grand total line. Thanks for your help. "Dave Peterson" wrote: I'd try removing those subtotals once more. Make sure you select the entire range before you do it, though. Melody wrote: I have Excel 2003. I have a spreadsheet that I have run subtotals on. However, when I do Remove All to remove the subtotals the grand total and the +- bar is still there. How can I get rid of all the totals in the spreadsheet including the grand total and the +- bar on the left? Thanks -- Dave Peterson -- Dave Peterson -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Removeing the Grand Total Line when subtotals are removed
Hi Melody
try DataSubtotalsRemove All -- Regards Roger Govier "Melody" wrote in message ... I have Excel 2003. I have a spreadsheet that I have run subtotals on. However, when I do Remove All to remove the subtotals the grand total and the +- bar is still there. How can I get rid of all the totals in the spreadsheet including the grand total and the +- bar on the left? Thanks |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Removeing the Grand Total Line when subtotals are removed
I did that. It removed the subtotals but not the grand total at the bottom.
"Roger Govier" wrote: Hi Melody try DataSubtotalsRemove All -- Regards Roger Govier "Melody" wrote in message ... I have Excel 2003. I have a spreadsheet that I have run subtotals on. However, when I do Remove All to remove the subtotals the grand total and the +- bar is still there. How can I get rid of all the totals in the spreadsheet including the grand total and the +- bar on the left? Thanks |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Removeing the Grand Total Line when subtotals are removed
ps. depending on what you're counting/summing/averaging..., you may want to try
data|pivottables. You may find them quicker to use and the reports nicer. Melody wrote: I have Excel 2003. I have a spreadsheet that I have run subtotals on. However, when I do Remove All to remove the subtotals the grand total and the +- bar is still there. How can I get rid of all the totals in the spreadsheet including the grand total and the +- bar on the left? Thanks -- Dave Peterson |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Removeing the Grand Total Line when subtotals are removed
I agree, but unfortunately, I don't have any control over the content and
style of the spreadsheet. If I did, it would a lot more user friendly. I will try your other suggestion, though and let you know how it goes. Thanks. "Dave Peterson" wrote: ps. depending on what you're counting/summing/averaging..., you may want to try data|pivottables. You may find them quicker to use and the reports nicer. Melody wrote: I have Excel 2003. I have a spreadsheet that I have run subtotals on. However, when I do Remove All to remove the subtotals the grand total and the +- bar is still there. How can I get rid of all the totals in the spreadsheet including the grand total and the +- bar on the left? Thanks -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Should grand total equal average of sub total | Excel Discussion (Misc queries) | |||
| show only the subtotals and grand total in a pivot table | Excel Worksheet Functions | |||
| Pivots - Auto calc % Sub total is of grand total | Excel Discussion (Misc queries) | |||
| Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions | |||
| grand-total of subtotals ? | Excel Worksheet Functions | |||
Hybrid Mode
