ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   create an outline in excel (https://www.excelbanter.com/excel-discussion-misc-queries/113451-create-outline-excel.html)

Outline in Excel

create an outline in excel
 
Does anybody know how to set the +/- grouping feature so that it's directly
adjacent to the row instead of to the line time beneath it?

Dave Peterson

create an outline in excel
 
Outlining rows can be created a couple of ways:

Data|subtotal (inserts subtotal rows, too)

or
(select the rows to group)
Data|Group and Outline|group

Outline in Excel wrote:

Does anybody know how to set the +/- grouping feature so that it's directly
adjacent to the row instead of to the line time beneath it?


--

Dave Peterson

Lori

create an outline in excel
 
Choose Data - Group and Outline - Settings and uncheck Summary rows
below detail followed by OK



All times are GMT +1. The time now is 07:26 PM.

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