ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   HOW CAN I COLLAPSE AND EXPAND COLUMS (https://www.excelbanter.com/excel-discussion-misc-queries/84332-how-can-i-collapse-expand-colums.html)

JVICO

HOW CAN I COLLAPSE AND EXPAND COLUMS
 
I would like to expand and collapse groups of columns just like the subtotal
function does with rows; with a minus sign to collapse and a plus sign to
expand in the gray area for rows. Could I do that with columns?

Dave Peterson

HOW CAN I COLLAPSE AND EXPAND COLUMS
 
Not using data|subtotals, but you can use Data|Group and outline.

Select a few columns and do Data|Group and outline|group.



JVICO wrote:

I would like to expand and collapse groups of columns just like the subtotal
function does with rows; with a minus sign to collapse and a plus sign to
expand in the gray area for rows. Could I do that with columns?


--

Dave Peterson


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

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