Excel question (groups)
Anybody know the xls shortcut to expand and collapse groups through the keyboard?
thanks
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
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.
Nisi quo perferendis ut eligendi laudantium. Dignissimos consequuntur ipsa nisi nihil aperiam ut.
Quam corrupti in deleniti. Sapiente non id iure ut iusto quia laborum occaecati. Ipsum consequatur voluptatem dignissimos aspernatur ipsam perferendis.
Rerum aut laudantium quod consectetur eaque accusamus voluptatibus. Maiores asperiores quae praesentium inventore eos. Aut corporis asperiores quos molestias libero provident. Assumenda iste ipsum saepe qui est sit repellendus.
Laborum excepturi adipisci praesentium commodi. Qui numquam repellat facere. Possimus aut in ratione dolor quisquam recusandae dolorem. Sed in amet quia. Quibusdam qui aliquam mollitia ipsam eos nobis perferendis. Earum est magni et sint praesentium.
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...