ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Expanding/Collapsing Rows? (https://www.excelbanter.com/excel-worksheet-functions/19313-expanding-collapsing-rows.html)

Jake

Expanding/Collapsing Rows?
 
Is there another way to collapse rows of information without using the 'Hide'
feature? I'm looking for an expading tree type view, such as you would find
in explorer.

Dave Peterson

Select some rows, then Data|Group

Or you could apply Data|Subtotals (and get the added benefit of subtotals!)

Jake wrote:

Is there another way to collapse rows of information without using the 'Hide'
feature? I'm looking for an expading tree type view, such as you would find
in explorer.


--

Dave Peterson

Ragdyer

This might provide exactly the help that you're looking for:

http://tinyurl.com/6uc2p

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Jake" wrote in message
...
Is there another way to collapse rows of information without using the

'Hide'
feature? I'm looking for an expading tree type view, such as you would

find
in explorer.




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

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