#1   Report Post  
Posted to microsoft.public.excel.misc
teksmith
 
Posts: n/a
Default Outline Styles

When I create an outline of rows, the expand button (+) is placed on the row
below the group as opposed to the header row. Additionally, if I turn on
Automatic Style, the row below the group is made bold. Is there anyway to
make the (+) button align with the header row? Is there anyway to have
automatic style bold the real header row not the row below the group?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Outline Styles

Data|Group and Outlines|Settings|Uncheck Summary rows below detail

I don't use the automatic styles very often--but I don't think you can change
them.

teksmith wrote:

When I create an outline of rows, the expand button (+) is placed on the row
below the group as opposed to the header row. Additionally, if I turn on
Automatic Style, the row below the group is made bold. Is there anyway to
make the (+) button align with the header row? Is there anyway to have
automatic style bold the real header row not the row below the group?


--

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
Sheet protection and "Group and Outline" OkieViking Excel Discussion (Misc queries) 9 May 22nd 07 05:17 PM
Group & Outline and Recalculation BrianH Excel Discussion (Misc queries) 3 April 20th 06 09:19 AM
Conditional Format - Outline Border Drahos Excel Worksheet Functions 2 February 1st 06 09:42 AM
Macro to show/hide detail in an outline NathanPage Excel Discussion (Misc queries) 1 December 8th 05 03:10 PM
Excel Styles Problem Frustrated Excel Discussion (Misc queries) 1 October 30th 05 10:24 PM


All times are GMT +1. The time now is 03:40 AM.

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

About Us

"It's about Microsoft Excel"