ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Using Outlines in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/16439-using-outlines-excel.html)

Sandi

Using Outlines in Excel
 
What is the different when you change your summary columns to the right of
detail? When I turn this feature on or off - it still displays the same
infomation wether it's selected or not. What is this used for?
--
Sandi Gardner

Dave Peterson

If you click on those +/- characters, you can expand/contract the details.
They'll still be there, but they'll be hidden--kind of like Autofilter can be
used to hide rows.

In fact, if you used Data|subtotals to apply the outlining, there are numbers at
the top of those +/-'s that can hide/show that whole level.



Sandi wrote:

What is the different when you change your summary columns to the right of
detail? When I turn this feature on or off - it still displays the same
infomation wether it's selected or not. What is this used for?
--
Sandi Gardner


--

Dave Peterson


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

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