| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting subtotal lines
Can anyone tell me if it is possible to format only the subtotal lines in an excel spreadsheet? I have been manually selecting the rows and changing the text to bold and the background color to grey so they will stand out from the rest of the report. I know there must be an easier way to do this and if anyone can help me out I would appreciate it very much. -- david4141955 ------------------------------------------------------------------------ david4141955's Profile: http://www.excelforum.com/member.php...o&userid=37503 View this thread: http://www.excelforum.com/showthread...hreadid=571549 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formatting subtotal lines
Warning !!! On a back up copy of your File
Go to level Two (2) of your sub-totals which generally shows only your Sub-totals; While there at the menu, select Edit, GoTo, Special Button.. click on Visible Cells Only (far right near bottom of dialog box); Apply your formatting; Go back to Level 1; Maybe that'll work "david4141955" wrote: Can anyone tell me if it is possible to format only the subtotal lines in an excel spreadsheet? I have been manually selecting the rows and changing the text to bold and the background color to grey so they will stand out from the rest of the report. I know there must be an easier way to do this and if anyone can help me out I would appreciate it very much. -- david4141955 ------------------------------------------------------------------------ david4141955's Profile: http://www.excelforum.com/member.php...o&userid=37503 View this thread: http://www.excelforum.com/showthread...hreadid=571549 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formatting subtotal lines
Thank you! That worked. -- david4141955 ------------------------------------------------------------------------ david4141955's Profile: http://www.excelforum.com/member.php...o&userid=37503 View this thread: http://www.excelforum.com/showthread...hreadid=571549 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting Error | Excel Worksheet Functions | |||
| difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
| conditional formatting question | Excel Discussion (Misc queries) | |||
| How do I remove the individual subtotal lines from a pivot table.. | Excel Discussion (Misc queries) | |||
| Formatting lines between data points in a line chart | Charts and Charting in Excel | |||
Linear Mode
