Excel experts...
If you create a bunch of groups on the side, can you label those?
Trending Content - Investment Banking Forum
| +313 | UBS Tech MD hires Son (from no-name college) as an Intern | 54 | 1h |
| +89 | [Official] 2026 IB Analyst Bonus Megathread (with 2025 Consolidated Pay and Perks/Benefits) | 12 | 1d |
| +52 | Is DCM actually underrated ? | 18 | 7h |
| +46 | Are all Tech / TMT groups sweaty? | 31 | 7h |
| +41 | UBS Groups Ranked by Future Outlook | 20 | 4d |
| +40 | JPM M&A is Gone??? Purely Coverage Banking??? | 20 | 7h |
| +37 | Am I behind? 31 Year Old Analyst | 10 | 10h |
| +32 | UVA McIntire vs Cornell Dyson for IB | 19 | 3d |
| +32 | Losing my personality in Banking | 5 | 22h |
| +31 | Incoming IB Analyst: Best Ways to Prepare? | 8 | 22h |
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)
Aut velit iste consequatur. Corporis expedita tempore rem laudantium voluptates aut rerum.
In sit quis officia fugiat. Aut vel id non voluptas provident qui assumenda. Amet omnis ut ullam ab unde.
Ea ex eius ipsam non. Provident quisquam tempora doloremque aut ab soluta adipisci. Facilis voluptas similique excepturi repellendus in dignissimos.
Eaque unde velit velit dolores. Molestias et similique ut voluptatem. Quis maxime excepturi explicabo eveniet vero non. Doloribus sint aut quos veniam provident.
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...