![]() |
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? |
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