Excel experts...
If you create a bunch of groups on the side, can you label those?
Trending Content - Investment Banking Forum
| +178 | Americas M&A League Table Q2 Updated | 73 | 10h |
| +132 | New Article: Dramatic Slide as UBS #22 (US) & New Leadership Desperately Needed | 26 | 18m |
| +108 | Restructuring: Anti-climactic Experience | 26 | 8h |
| +74 | A COMPLETE GUIDE TO SUMMER INTERNSHIP RECRUITING | 12 | 1d |
| +74 | IB Net Worth / Savings Check | 29 | 2h |
| +51 | Boutique firm wants access to my LinkedIn? | 40 | 1d |
| +39 | Investment Banking is Hard | 17 | 19h |
| +31 | PWP vs BofA | 23 | 2h |
| +25 | Who pays the highest right now? | 14 | 3h |
| +21 | Big 4 Transaction diligence (FDD) vs Valuations and modeling for goal to get in IB | 5 | 4d |
Career Resources
What in sam hill are you talking about?
If you highlight rows and go to data --> group, it creates little + / - signs on the side to keep track of everything. Instead of having a spreadsheet full of + / - signs, is there anyway to label those?
Thanks
Ohhh, ok. No, why would you need to name them? In the top left hand corner there will be numbered boxes, depending on which one you click it will collapse/expand a given level of grouped rows/columns.
What you can do is have a total row which is not hidden, that way you know whats hidden under it.
ie.
NA TOTAL SALES (is a sum of the below 3) -US Sales -Mexico Sales -Canada Sales
Europe TOTAL SALES (is a sum of the below 3) -UK Sales -Germany Sales -Belgium Sales
Asia TOTAL SALES (is a sum of the below 3) -China Sales -Japan Sales -Korea Sales
So you group all the sub-items which is each country. When you click the #1 it hides all the sub items and all you see is each region specific sales figure. When you click the #2 box, it expands all the country specific sales out.
It effectively names the group which resides under it.
cool thanks man
Is there a shortcut to expand or close the grouped rows/columns, or do you just have to click on it?
Highlight the hidden rows by highlighting the cell above the rows, then hit Shift+Down to highlight hidden cells. Hit Alt-D-G-S to unhide the rows. If you want to hide the cells, simply highlight one of the cells in the group and hit Alt-D-G-H.
Or...
Ctrl+Shift+9 to show Rows, Ctrl+9 to Hide Rows Ctrl+Shift+0 to show Columns, Ctrl+0 to Hide Columns
Or shift+alt+right or left arrow to group and ungroup
after you did ALT+D+G+G, to actually hide or unhide the grouped selection you do the following:
for colums: CTRL+) (to hide) CTRL+SHIFT+) (to unhide)
for rows: CTRL+( (to hide) CTRL+SHIFT+( (to unhide)
Excepturi temporibus et officiis eum quas quasi. Omnis repudiandae est iusto placeat assumenda voluptatem reiciendis. Voluptates culpa pariatur ullam commodi voluptatem fuga asperiores quia.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...