Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 5th 06, 01:57 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 2
Default Bolding the subtotal lines automaticlly When using the Subtotal fu

I know how to use the subtotal function, but only the colum which I am
sorting by is bold. How do I get the whole total line to be bold so I can
easiely tell what I am looking at?

  #2   Report Post  
Old October 5th 06, 02:35 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default Bolding the subtotal lines automaticlly When using the Subtotal fu

After you apply the subtotals, use the outlining symbols to the left to hide the
details--just show what you want bolded.

Then select that range to bold
Edit|Goto|special|visible cells only
and format those visible cells the way you want.

06Speed6 wrote:

I know how to use the subtotal function, but only the colum which I am
sorting by is bold. How do I get the whole total line to be bold so I can
easiely tell what I am looking at?


--

Dave Peterson
  #3   Report Post  
Old October 5th 06, 03:52 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 2
Default Bolding the subtotal lines automaticlly When using the Subtota

Dave,

Thanks for your help it works just as I wanted it to.

"Dave Peterson" wrote:

After you apply the subtotals, use the outlining symbols to the left to hide the
details--just show what you want bolded.

Then select that range to bold
Edit|Goto|special|visible cells only
and format those visible cells the way you want.

06Speed6 wrote:

I know how to use the subtotal function, but only the colum which I am
sorting by is bold. How do I get the whole total line to be bold so I can
easiely tell what I am looking at?


--

Dave Peterson



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I color only subtotal lines in Excel 2002? dfw in NJ Excel Worksheet Functions 4 October 5th 06 03:55 PM
formatting subtotal lines david4141955 Excel Discussion (Misc queries) 2 August 14th 06 10:23 PM
how can I print and sort JUST the subtotal lines, not the detail kamaladg Excel Discussion (Misc queries) 1 July 11th 06 12:34 AM
SUBTOTAL - TJ TJ Excel Worksheet Functions 4 March 22nd 06 07:06 PM
How do I remove the individual subtotal lines from a pivot table.. leo Excel Discussion (Misc queries) 2 March 16th 05 04:19 AM


All times are GMT +1. The time now is 11:39 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017