Excel question (groups)
Anybody know the xls shortcut to expand and collapse groups through the keyboard?
thanks
Trending Content
Career Resources
WSO Free Modeling Series - Now Open Through
April 30, 2024
9 Free Financial Modeling Lessons
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
+Bonus: Get 27 financial modeling templates in swipe file
+Bonus: Get 27 financial modeling templates in swipe file
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.
Vitae voluptas saepe non. Eos rerum officiis aut et similique.
Soluta dolor hic pariatur accusantium expedita. Non esse rerum quas non molestias. Incidunt aut id aut nemo. Laudantium molestiae deserunt ad.
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...