Here, two sections are already grouped at level 2.Ģ. You can create multiple groups at each inner level. To outline an inner, nested group of detail columns (level 2 or higher), select the detail columns adjacent to the column that contains the summary column.ġ. The outline symbol appears above the group. On the Data tab, in the Outline group, click Group. Note that if you don't select entire columns, when you click Group (on the Data tab in the Outline group) the Group dialog box will open and ask you to choose Rows or Columns. Select all the detail and subtotal columns. To outline the outer group (level 1), select all of the subordinate summary columns, as well as their related detail data.Ģ. Important: When you manually group outline levels, it's best to have all data displayed to avoid grouping columns incorrectly. On the Data tab, in the Outline group, click the arrow under Group, and then click Auto Outline. Select a cell in the range of cells you want to outline. Then in the Settings dialog box, clear the Summary rows below detail checkbox, and then click OK. If you created your summary rows above your detail rows, on the Data tab, in the Outline group, click the dialog box launcher. If you created the summary rows below the details, skip to the next step (step 4). The table later in this topic shows you an example of this.īy default, Excel looks for summary rows below the details they summarize, but it's possible to create them above the detail rows. For example, under (or above) the rows of sales data for March and April, use the SUM function to subtotal the sales for those months.
Insert your own summary rows, with formulas, immediately below or above each group of detail rows. For more information about using the Subtotal function, see SUBTOTAL function. Use the Subtotal command, which inserts the SUBTOTAL function immediately below or above each group of detail rows and automatically creates the outline for you.
Insert summary rows by using the Subtotal command To create these, do one of the following: If you want, your grouped detail rows can have a corresponding summary row-a subtotal. Make sure that each column of the data that you want to outline has a label in the first row (e.g., Region), contains similar facts in each column, and that the range you want to outline has no blank rows or columns. To expand or collapse data in your outline, click the and outline symbols, or press ALT+SHIFT+= to expand and ALT+SHIFT+- to collapse. Level 3 contains detail rows - in this case, rows 17 through 20.ĥ. Level 2 contains total sales for each month in each region.Ĥ.
Level 1 contains the total sales for all detail rows.ģ. To display rows for a level, click the appropriate outline symbols.Ģ. You can create an outline of rows (as shown in the example below), an outline of columns, or an outline of both rows and columns.ġ. Use an outline to quickly display summary rows or columns, or to reveal the detail data for each group. Each inner level, represented by a higher number in the outline symbols, displays detail data for the preceding outer level, represented by a lower number in the outline symbols. If you have a list of data you want to group and summarize, you can create an outline of up to eight levels. Many thanks for any guidance you can offer.Excel for Microsoft 365 Excel for the web Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 More. Separately, is there any other feature or set of commands I can use to achieve the same results, in either the older or newer version of Word for Mac?
MAC OUTLINER FOR MAC
Is there a "Collapsible Subdocuments" feature in the Outline View (or anywhere else) in Word for Mac 2016? Or even Word for Mac 2011? I need a feature like this-either this exact feature or some equivalent-for a project I'm working on, in which I'm adding thousands of lines of details and notes across dozens of sections of the document I want to be able to immediately access the details notes as needed (so I DON'T want to store them in separate documents elsewhere on my hard drive), but also to keep them hidden, or collapsed, most of the time. You can click to collapse all the text below the heading and above the following heading of the same level, and click again to make that text visible again.
MAC OUTLINER WINDOWS
There's a feature of Word 2016 for Windows that I can't find in a sample version of Word for Mac 2016: In the Windows version, in Outline View, there's the option of activating "Collapsible Subdocuments" when you do this, every line in a document that you've designated as a "heading" (at whatever level-"Heading 1," "Heading 2," etc.) becomes clickable, and when you hover one of these headings, a small gray triangle appears next to it.
0 kommentar(er)
