![]() ![]() Also, you can expand/collapse all categories at once by clicking on a number at the top of the outline bar. ![]() In the outline bar, you can expand or collapse rows using the plus/minus sign next to total rows. In the Subtotal window, (1) choose Month in the first drop-down list, and (2) check Total Sales, for adding subtotal to, and (3) click OK.Īs a result, the outline is created on the left side of the data, and subtotals are added. Select any cell in the range (for this example, B3:G16).ģ. For example, let’s add subtotals for Total Sales (Column G), by Product (D).ġ. To create an outline, one option is to add subtotals to the data range. Say you have the following range of values. This can help to group rows in order to outline data in complex data sets. You can also use an outline to display subtotals. In this tutorial, you will learn how to create an outline in Excel and Google Sheets.Īn outline in Excel allows you to group or ungroup rows.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |