Sub-Totals Question
Using the sub-totals feature in Excel the category being subtotaled is
highlighted in bold but the subtotals themselves are not highlighted. Is there a way to format these items either using excel "as is" or with some simple code? Thanks, Andrew. |
Sub-Totals Question
Use the outlining symbols to the left to show just what you want to format (hide
those details). Now select the range to format edit|goto|special|visible cells only and format the way you like. You could record a macro if you want the code. Andrew Mackenzie wrote: Using the sub-totals feature in Excel the category being subtotaled is highlighted in bold but the subtotals themselves are not highlighted. Is there a way to format these items either using excel "as is" or with some simple code? Thanks, Andrew. -- Dave Peterson |
Sub-Totals Question
Thanks Dave - bloody marvellous!
"Dave Peterson" wrote in message ... Use the outlining symbols to the left to show just what you want to format (hide those details). Now select the range to format edit|goto|special|visible cells only and format the way you like. You could record a macro if you want the code. Andrew Mackenzie wrote: Using the sub-totals feature in Excel the category being subtotaled is highlighted in bold but the subtotals themselves are not highlighted. Is there a way to format these items either using excel "as is" or with some simple code? Thanks, Andrew. -- Dave Peterson |
All times are GMT +1. The time now is 07:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com