![]() However, there is an even faster way of hiding and showing the details of an outlined spreadsheet.Īt the top of the worksheet, there are numbered buttons arranged in a row. Using this method, you can quickly hide the details of your spreadsheet and only view the totals. Now, only the quarterly and yearly totals are displayed: (In this case, there is only one year.)Ĭlick the collapse buttons beside each quarter: As well, each year has been grouped together. In the sample worksheet, each quarter has been grouped with the other quarters. 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: The results of Excel’s automatic outlining feature will now be displayed: To start, click Data → Group → Auto Outline: 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:Īs 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. ![]() 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 |