formatting subtotals

[Guest]

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

 

[Frank Kabel]

Hi
after collpasing the data and selecting the data try:
- hit F5, choose 'Special'
- select 'Only visible cells'

Now apply your format

 

[Guest]

Works like a charm - thanks!

Hi
after collpasing the data and selecting the data try:
- hit F5, choose 'Special'
- select 'Only visible cells'

Now apply your format