![]() You will now have group and outline buttons to collapse all sections. Press Ctrl+Alt+Up arrow to return the monitor to the correct orientation. Gotcha: When you mistakenly press Ctrl+Alt+Right arrow, your display may turn sideways (as if you were going to mount your monitor in a portrait fashion). Press Shift+Alt+RightArrow to group the selection. Select the rows for Section 1, excluding the heading.Ĥ. Select the rows underneath the heading for section 1.įigure 708. In the Settings dialog, uncheck Summary Rows Below Detail.įigure 707. On the Data tab, click the Dialog Launcher in the corner of the Outline group.Ģ. It creates an uncluttered view of the model.ġ. Mack uses this trick in his models, with multiple levels of grouping. There is an obscure setting that makes grouping work the way you want it to work. Strategy: I picked up this great trick from Mack Wilk, one of the two-time ModelOff World Financial Modeling finalists. ![]() What if I have report headings above each section and I need to group the data below the heading? ![]() Problem: The grouping feature feels backwards. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |