Home

shrink columns and reopen later

%3CLINGO-SUB%20id%3D%22lingo-sub-864190%22%20slang%3D%22en-US%22%3Eshrink%20columns%20and%20reopen%20later%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-864190%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20shrink%2Fminimize%20a%20wide%20database%20of%20columns%20for%20ease%20of%20working%20on%20current%20section%20and%20then%20re-open%20minimized%20section%20later.%20Minimizing%20is%20easy%2C%20but%20accessing%20and%20re-opening%20the%20minimized%20section%20is%20proving%20difficult..%20-%20any%20answers%20please%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-864190%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-888622%22%20slang%3D%22en-US%22%3ERe%3A%20shrink%20columns%20and%20reopen%20later%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-888622%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F412141%22%20target%3D%22_blank%22%3E%40trickydicky%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20many%20of%20the%20columns%20%26nbsp%3Byou%20seek%20to%20%22shrink%22%20are%20side-by-side%2C%20you%20may%20want%20to%20group%20them.%20In%20the%20Data%20menu%20you%20find%20%22Group%20and%20outline%22.%20Alternatively%2C%20on%20the%20Data%20ribbon%20you%20will%20find%20%22Group%22%20button.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESelect%20the%20columns%20you%20want%20to%20%22shrink%22%20and%20apply%20Group.%20It%20will%20place%20a%20plus%2Fminus%20toggle%20above%20the%20next%20column%20and%20it%20will%20place%20some%20grouping%20level%20indicators%20towards%20the%20top%20left.%20Press%20the%20buttons%20and%20see%20see%20if%20this%20achieves%20what%20you%20are%20after.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAttaching%20a%20sceen%20shot.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
trickydicky
Occasional Visitor

I need to shrink/minimize a wide database of columns for ease of working on current section and then re-open minimized section later. Minimizing is easy, but accessing and re-opening the minimized section is proving difficult.. - any answers please

1 Reply
Highlighted

@trickydicky 

If many of the columns  you seek to "shrink" are side-by-side, you may want to group them. In the Data menu you find "Group and outline". Alternatively, on the Data ribbon you will find "Group" button.

 

Select the columns you want to "shrink" and apply Group. It will place a plus/minus toggle above the next column and it will place some grouping level indicators towards the top left. Press the buttons and see see if this achieves what you are after.

 

Attaching a sceen shot. 

 

Related Conversations
Last Value Column from Another Column in Same List
Yepitsme in SharePoint on
6 Replies
Add Column Using Count
Tim Hunter in SQL Server on
0 Replies
Taking values from certain rows based on data input
Drakerla in Excel on
5 Replies
O365 SharePoint List Column Names Corrupted
Lori Hanley in SharePoint on
6 Replies
reverse text to columns for .csv import
milly87 in Excel on
3 Replies
Change default views for subfolders
mlilindstrom in SharePoint on
2 Replies