If you choose not to use the Automatic Styles option before creating your outline, you can do so later. Along with the outline itself, this helps make the data a bit easier to read and distinguish it from the rest. A minus sign will reduce that particular set of lines.Īs mentioned earlier, you can apply styles to your outline to make the lines and summary lines stand out. If you click on a plus sign, it will expand that particular set of lines in the outline. If you click on a number, it will collapse or expand that whole level. You can use numbers, plus and minus signs, or both to collapse and expand your lines. You can have up to eight levels in an Excel outline. The numbers and buttons continue for each level until the last. The next highest number (2) and the buttons below correspond to the second highest level. The lowest number (1) and the leftmost buttons below the 1 correspond to your top level view. This includes numbers, matching rows, and plus and minus signs in the gray area to the left of rows or at the top of columns. You should see your spreadsheet update immediately to view the plan. Select your cells, go to the Data tab and click on "Plan".Ĭlick on the “Group” arrow and choose “Auto Outline” from the drop-down list. If you've defined your summary lines and other plan requirements, it's time to create your plan. If you choose not to use automatic styles here, we'll also show you how to apply them later.Ĭlick "OK" and get ready to create the outline.
This will format the cells in your outline with bold, italic, and similar styles to make them stand out. When the Settings window opens, uncheck the "Summary lines under details" box.īefore clicking “OK”, you can optionally check the “Automatic styles” box. Then click on the dialog box launcher (small arrow) at the bottom right of the pop-up window. Select the cells you want to define and go to the Data tab.Ĭlick "Outline" on the right side of the ribbon. However, there is a way to handle this if your summary rows are currently positioned above. It's easier to place your summary rows below the data they summarize. Each column should include similar data.Each column must have a header or label in the first row.In order for the feature to achieve its purpose, there are a few things you need to include in your data: You can apply the same principles if you want an outline for the columns. To explain the basics of this topic, we are going to create an outline of lines. In Microsoft Excel, you can create an outline of rows, columns, or both. Format styles after creating the outline.What you need to create a plan in Excel.
0 kommentar(er)
