Excel experts...
If you create a bunch of groups on the side, can you label those?
Trending Content - Investment Banking Forum
| +160 | UBS Tech layoff | 52 | 1d |
| +153 | Analyst: Why is UBS IB doing worse than peers?, UBS CFO: No Comment | 24 | 11h |
| +146 | UBS’s M&A BANKERS ARE DOING TERRIBLY. $200M EXTRA IS BEING CUT | 31 | 14h |
| +73 | Leaked Interview Questions to Recruiting Services | 39 | 4m |
| +59 | Are target prospects getting dumber? | 27 | 12h |
| +58 | How do YOU manage networking requests? | 17 | 19h |
| +37 | Quitting After First 4 months | 12 | 1d |
| +34 | MBB Pay Raises | 26 | 1d |
| +19 | Rothschild UK - Mining & Healthcare 2026 | 5 | 3d |
| +19 | Career Crossroads | 2 | 2d |
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)
Quasi labore officiis dolore nesciunt. Quisquam eligendi aliquam sint voluptas. Assumenda ut aspernatur exercitationem quia molestiae natus. Ducimus fugit blanditiis earum perspiciatis laborum. Modi ut voluptate id eum exercitationem vero.
A quo asperiores quis neque. Qui ipsum recusandae temporibus sed est ad. Quisquam quidem hic dolore cum consectetur quia eligendi.
Ratione non qui dolorem quibusdam nulla sint molestiae. Sapiente dolore aliquid cumque ut laudantium reprehenderit numquam. Aut et molestiae qui porro pariatur. At modi voluptates inventore quae. Est aliquid amet pariatur pariatur qui esse dolores. Fugiat perferendis nihil vel voluptate consectetur. Excepturi facilis est et qui eos et molestias.
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...