![]() (In this case, there is only one year.) Click the collapse buttons beside each quarter: Now, only the quarterly and yearly totals are displayed: Using this method, you can quickly hide the details of your spreadsheet and only view the totals. ![]() As well, each year has been grouped together. To start, click Data → Group → Auto Outline: The results of Excel’s automatic outlining feature will now be displayed: You will see that outline group indicators (the thick black lines that look like large brackets) and collapse buttons (marked with a minus sign) are now part of the worksheet: Showing and Hiding Outline Details In the sample worksheet, each quarter has been grouped with the other quarters. This Group button is in Page Layout tab> Arrange. Since another Group button is used to combine Shapes, pictures, or other objects and it is greyed out by default. To help get around this problem, you can outline the data. Assuming that you want to Group outline of columns in your documents with the Group button make sure the Group button you want to use is in the Data tab>Outline. For example, the sample image below contains monthly sales data, organized into quarterly and yearly totals using formulas: As you can see, it can be difficult to discern the quarterly and yearly totals at a glance because they blend in with the other data in the worksheet. ![]() Automatic outlining works best with numerical data organized into groups and sub groups by formulas or functions. The Outline Feature in Excel Excel’s automatic outlining feature makes outlining a worksheet easy.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |