I have tried the selections in Options-> Advanced setting, but that doesn't work. However now the grouping is not visible anymore. After removal of all the groupings in that sheet, I wanted to add them back again. (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. The outline or grouping of my columns is not visible anymore for one particular sheet in my excel model. 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. To help get around this problem, you can outline the data. 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 |