| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
would like each subtotal line highlighted
I have subtotaled a a/p list and would like the have each subtotal line
highlighted |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
would like each subtotal line highlighted
Have you looked at Format - Auto Format... It usually does a nice job of
formatting sub-totals. -- HTH... Jim Thomlinson "sjs" wrote: I have subtotaled a a/p list and would like the have each subtotal line highlighted |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
would like each subtotal line highlighted
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??? sjs wrote: I have subtotaled a a/p list and would like the have each subtotal line highlighted -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotal: Totals line output | Excel Discussion (Misc queries) | |||
| In Excel 2007 PivotTables, what happened to "hiding" subtotal line | Excel Discussion (Misc queries) | |||
| How do you add a blank line automatically after the Subtotal line | Excel Worksheet Functions | |||
| HOW DO I MOVE A DESCRIPTION OR NAME INTO A SUBTOTAL LINE | Excel Worksheet Functions | |||
| Subtotal line selection | Excel Discussion (Misc queries) | |||
Linear Mode
