Show/Hide Subrows

%3CLINGO-SUB%20id%3D%22lingo-sub-2150933%22%20slang%3D%22en-US%22%3EShow%2FHide%20Subrows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2150933%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20really%20like%20to%20have%20a%20way%20to%20nest%20rows%20into%20categories%20that%20can%20be%20expanded%20and%20condensed%20as%20needed.%20This%20would%20be%20especially%20useful%20for%20things%20like%20budgets%20where%20everything%20could%20be%20viewed%2C%20but%20also%20it%20could%20condense%20down%20to%20just%20the%20main%20categories%20for%20a%20higher-level%20look.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20looked%20at%20using%20the%20%22Group%22%20feature%20under%20Data%2C%20but%20this%20isn't%20the%20solution%20I%20had%20in%20mind.%20I%20have%20a%20spreadsheet%20that%20was%20exported%20from%20QuickBooks%20which%20has%20little%20clickable%20plus%2Fminus%20signs%20on%20the%20rows%20which%20is%20really%20neat%3B%20it%20has%20hundreds%20of%20rows%20but%20condenses%20down%20into%20just%204%20main%20ones%20(see%20screenshots).%20However%2C%20I%20can't%20figure%20out%20how%20to%20enable%20these%20plus%2Fminus%20signs%20on%20a%20different%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20suggestions%20are%20greatly%20appreciated!%20Thanks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Rows%202.PNG%22%20style%3D%22width%3A%20115px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F256220iADAAD9D9C701A92D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Rows%202.PNG%22%20alt%3D%22Rows%202.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Rows.PNG%22%20style%3D%22width%3A%20211px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F256221iF3F19CD34C0C63F9%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Rows.PNG%22%20alt%3D%22Rows.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2150933%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2151183%22%20slang%3D%22en-US%22%3ERe%3A%20Show%2FHide%20Subrows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2151183%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F972833%22%20target%3D%22_blank%22%3E%40RuthLee%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThose%20look%20like%20Pivot%20Tables%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHighlight%20your%20block%20of%20data%2C%26nbsp%3B%20press%20Ctrl%20T%20to%20turn%20the%20data%20into%20a%20Table%20and%20then%20select%20the%20Summarize%20with%20Pivot%20Table%20option%20that%20appears%20in%20the%20menu%20bar%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,

 

I would really like to have a way to nest rows into categories that can be expanded and condensed as needed. This would be especially useful for things like budgets where everything could be viewed, but also it could condense down to just the main categories for a higher-level look.

 

I've looked at using the "Group" feature under Data, but this isn't the solution I had in mind. I have a spreadsheet that was exported from QuickBooks which has little clickable plus/minus signs on the rows which is really neat; it has hundreds of rows but condenses down into just 4 main ones (see screenshots). However, I can't figure out how to enable these plus/minus signs on a different sheet.

 

Any suggestions are greatly appreciated! Thanks.

 

Rows 2.PNG

Rows.PNG

2 Replies

Hi @RuthLee 

 

Those look like Pivot Tables

 

Highlight your block of data,  press Ctrl T to turn the data into a Table and then select the Summarize with Pivot Table option that appears in the menu bar

@Wyn Hopkins 

Ah, I see. I'll check that out and try it. Thanks!