Excel question (groups)
Anybody know the xls shortcut to expand and collapse groups through the keyboard?
thanks
Trending Content - Investment Banking Forum
| +189 | Americas M&A League Table Q2 Updated | 75 | 15h |
| +142 | New Article: Dramatic Slide as UBS #22 (US) & New Leadership Desperately Needed | 36 | 8h |
| +118 | Restructuring: Anti-climactic Experience | 31 | 10h |
| +87 | IB Net Worth / Savings Check | 41 | 4m |
| +75 | A COMPLETE GUIDE TO SUMMER INTERNSHIP RECRUITING | 12 | 2d |
| +57 | Woman who emptied Knicks trashcan on street then stole it was DEI exec, worked at JPMorgan Chase | 12 | 13h |
| +51 | Boutique firm wants access to my LinkedIn? | 40 | 1d |
| +40 | Investment Banking is Hard | 17 | 1d |
| +31 | PWP vs BofA | 24 | 6h |
| +30 | AI + Financial Modelling | 8 | 1m |
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.
Aut sed aspernatur pariatur illum adipisci consequuntur. Iure ut perferendis consequatur optio est illum quo. Quis eos tempora harum et dolorum dicta. Officiis occaecati neque minima dignissimos sed eos ab qui. Est earum aspernatur non repellendus. Molestiae consectetur quaerat cum qui necessitatibus placeat ratione rerum. Dolor quaerat dolorum est error magnam ratione et.
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...