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/228864-re-outline-group-data-below.html)

Leon[_2_]

Outline/group data below
 
On 17 Mar., 00:04, Steve wrote:
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 -- Skjul tekst i anførselstegn -


- Vis tekst i anførselstegn -


Hi Dave

Thanks! :-)


All times are GMT +1. The time now is 05:23 PM.

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