| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
formatting subtotals
Works like a charm - thanks!
"Frank Kabel" wrote: Hi after collpasing the data and selecting the data try: - hit F5, choose 'Special' - select 'Only visible cells' Now apply your format -- Regards Frank Kabel Frankfurt, Germany S. H. Drew wrote: When using the "subtotals" function, the subtotal description gets bolded...but not the figures in the subtotal (example below). Is there anyway to change this? I want the results of the subtotal to be bolded, or otherwise highlighted. But when I collapse the spreadsheet to show only the subtotal results, and then highlight the subtotal figures and make them bold, all the detailed data in between the subtotal figures gets bold too. (these get bolded) (these do not, but I want them to be) 4140 011 2311 Total 2 4137 222 0000 Total 5 4137 223 0000 Total 7 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell formatting behaviour question | Excel Discussion (Misc queries) | |||
| Formatting dates in the future | Excel Worksheet Functions | |||
| Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
| Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
