ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Outline/group data below (https://www.excelbanter.com/excel-worksheet-functions/224500-re-outline-group-data-below.html)

Steve[_4_]

Outline/group data below
 
In xl2007, to the bottom right hand side of the "Outline" section
(where the group and ungroup buttons reside), click on the small
arrow. This is the setting section that Dave mentioned. Uncheck
Summary Rows Below Detail. This will accomplish what you are tyring
to do.



On Mar 13, 4:55*pm, Dave Peterson wrote:
In xl2003 menus, I can use:
Data|Groupand outline|Settings
and uncheck "Summaryrowsbelow detail"

I don't have xl2007 available, but I bet there's a similar option on the Data
tab in theGroupsection/group.





Leon wrote:

HiGroup


Using excel 2007.


I want to make egroup- outline - ofrows.


Want to have a line with a number and some text


[+] 8 text here


when i click the [+] it turns to [-] and thegroupappears over the
line #8


I want to have thegroupapper below the line *#8...


How do I do that?


--

Dave Peterson- Hide quoted text -

- Show quoted text -




All times are GMT +1. The time now is 06:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com