| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
subtotal functions
When subtotaling a large worksheet is there a way to color and line the
subtotals at the same time. Hope someone can help Louise |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
subtotal functions
Apply the data|Subtotals
Use the outlining symbols to the left to hide the details select the range to modify Edit|goto|special|visible cells only apply the formatting you like to those visible cells Then show all the range??? Louise wrote: When subtotaling a large worksheet is there a way to color and line the subtotals at the same time. Hope someone can help Louise -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
subtotal functions
You can apply an AutoFormat (Tools - Format - AutoFormat). The only caution
I would have is that for a file over 10,000 rows long the amount of time that this takes is exorbitant and the possiblility of crashing is high... -- HTH... Jim Thomlinson "Louise" wrote: When subtotaling a large worksheet is there a way to color and line the subtotals at the same time. Hope someone can help Louise |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
subtotal functions
thank you. I completely forgot about visible cells. I use it all the time.
Louise "Dave Peterson" wrote: Apply the data|Subtotals Use the outlining symbols to the left to hide the details select the range to modify Edit|goto|special|visible cells only apply the formatting you like to those visible cells Then show all the range??? Louise wrote: When subtotaling a large worksheet is there a way to color and line the subtotals at the same time. Hope someone can help Louise -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
subtotal functions
I will try this. I have not used this function. my file is over 10K rows.
Louise "Jim Thomlinson" wrote: You can apply an AutoFormat (Tools - Format - AutoFormat). The only caution I would have is that for a file over 10,000 rows long the amount of time that this takes is exorbitant and the possiblility of crashing is high... -- HTH... Jim Thomlinson "Louise" wrote: When subtotaling a large worksheet is there a way to color and line the subtotals at the same time. Hope someone can help Louise |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
subtotal functions
Dave:
I tried this and still having trouble. I have a file that is 10K rows. and I have to sort & subtotal 3 ways. is there an add-in for subtotals that maybe I can download that will give me formatting options at the same time it is subtotaling? "Dave Peterson" wrote: Apply the data|Subtotals Use the outlining symbols to the left to hide the details select the range to modify Edit|goto|special|visible cells only apply the formatting you like to those visible cells Then show all the range??? Louise wrote: When subtotaling a large worksheet is there a way to color and line the subtotals at the same time. Hope someone can help Louise -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
subtotal functions
No addin that I know.
Louise wrote: Dave: I tried this and still having trouble. I have a file that is 10K rows. and I have to sort & subtotal 3 ways. is there an add-in for subtotals that maybe I can download that will give me formatting options at the same time it is subtotaling? "Dave Peterson" wrote: Apply the data|Subtotals Use the outlining symbols to the left to hide the details select the range to modify Edit|goto|special|visible cells only apply the formatting you like to those visible cells Then show all the range??? Louise wrote: When subtotaling a large worksheet is there a way to color and line the subtotals at the same time. Hope someone can help Louise -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining subtotal and sumif functions | Excel Worksheet Functions | |||
| SUBTOTAL - TJ | Excel Worksheet Functions | |||
| Combining SUMIF and SUBTOTAL functions | Excel Worksheet Functions | |||
| Can you combined the SUMIF and SUBTOTAL functions in a formula? | Excel Worksheet Functions | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Linear Mode
