Aug 26, 2008 · Hi all, I'd like to be able to run a macro which would collapse or expand all grouped rows and columns for all selected worksheets. When I say collapse or expand, i don't …

Mar 2, 2010 · I'm using excel 2007 and have just discovered the grouping rows function (that does not use a pivot table - i.e. data > group > group) - which is awesome I have noticed that there …

Dec 14, 2007 · I have several groupings of rows in worksheet. I need to have each separate grouping be able to automatically expand or collapse based on a value in each group. ie- …

Oct 7, 2010 · Hi, I've trying to build a reporting system in Excel, so that a list of client names is expandable. Once you click on a Client name (Simiar to clicking a parent folder in windows) …

May 15, 2015 · Group/ungroup fully expands/collapses multiple rows/columns. I'm not trying to group rows together and then expand/collapse, and I don't want to fully collapse a row either. …

Jun 8, 2023 · I've found a solution without using macros. When you click "Protect Sheet" you are prompted to set a password and check a number of settings ("Allow all users of this worksheet …

Mar 26, 2007 · Hi all I have a worksheet in which I have many groups set up. This all works fine. I would like to add a couple of buttons to give users the option to collapse all groups, and to …

Feb 13, 2024 · I know how to collapse rows and columns. Is there a way to collapse tabs? For example, Lets say I have a document with 30 tabs. For my purposes, it's too many to have …

Feb 28, 2023 · How to collapse the Excel subtotals? This sort of depends on them having used Data, Subtotals in the first place. If they did that, then you should have three buttons out here …

Oct 10, 2016 · Expand / Collapse Rows based a Cell Value User2000 Sep 12, 2017 cell collapsed/hidden defaulted expand rows