Excel question (groups)
Anybody know the xls shortcut to expand and collapse groups through the keyboard?
thanks
Trending Content - Investment Banking Forum
| +273 | UBS Tech MD hires Son (from no-name college) as an Intern | 49 | 6h |
| +166 | WTF IS THIS COMPETITON | 59 | 20h |
| +121 | Is banking in the south more sustainable? | 29 | 1h |
| +97 | The Intern Starter Pack | 16 | 9h |
| +76 | Current State of the League Tables | 28 | 1d |
| +55 | [Official] 2026 IB Analyst Bonus Megathread (with 2025 Consolidated Pay and Perks/Benefits) | 9 | 20h |
| +49 | Perella Weinberg to Cut 10% of Workforce, Including Partners | 31 | 1d |
| +40 | UBS Groups Ranked by Future Outlook | 20 | 1d |
| +32 | PWP Layoffs????? | 18 | 3d |
| +31 | UVA McIntire vs Cornell Dyson for IB | 18 | 11h |
Career Resources
Alt d g g and Alt d g s
Not sure how to expand and collapse, but alt d g g will group things, alt d g s doesnt do anything...
alt d g s will show hidden data. Alt d g h will hide or collapse grouped data
I set my excel up to do Alt-G for grouping. Alt-DGG is standared
If you want to ungroup the rows or cells altogether.
ALT + SHIFT + arrow right = group ALT + SHIFT + arrow left = ungroup
Love the ALT + SHIFT + arrow(s) to group and ungroup.
is there a hot key to hide and show as well ?
ctrl + 9 is for rows (shift to unhide) ctrl + 0 is for columns (shift to unhide)
Do not ever hide rows or columns.
Wow -- hide and unhide?
Did you not hear about this:
http://abajournal.com/news/excel_error_by_a_cleary_gottlieb_associate_a…
"Barclays Capital has been forced to file a legal relief motion relating to its acquisition of Lehman Brothers' US assets after a reformatting error with an Excel spreadsheet resulted in 179 contracts being mistakenly included in the purchase agreement"
"The associate resized the rows when converting the spreadsheet into a PDF document, causing “hidden” contracts in the spreadsheet to be exposed. The spreadsheet, which had been e-mailed to the law firm by a Lehman representative, contained nearly 1,000 rows and more than 24,000 individual cells."
If you group rows first then you can hide/unhide using ctrl + 9 for rows (shift to unhide) and ctrl + 0 for columns (shift to unhide). As long as you group them first then the little "+" will be there and you won't lose the rows/columns.
Corrupti quo similique doloremque tempore sapiente odit. Odio distinctio ut quis rerum facilis.
Nostrum qui occaecati enim voluptatem amet. Provident ut omnis enim odit.
Repellat neque labore repellendus omnis. Nemo molestiae suscipit et. Eaque fuga distinctio recusandae vel. Minima placeat nam facilis vel. Et deserunt natus sunt autem. Et est totam perspiciatis in aut asperiores. Omnis dolorem ipsam harum quia nesciunt.
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...