When you want to apply a small tweak to the document, it should not require much time to Outline spreadsheet document. This sort of simple activity does not have to require extra education or running through guides to learn it. With the right document modifying tool, you will not take more time than is needed for such a swift change. Use DocHub to streamline your modifying process whether you are a skilled user or if it’s the first time making use of a web-based editor service. This tool will take minutes or so to figure out how to Outline spreadsheet document. The sole thing required to get more productive with editing is a DocHub account.
A plain document editor like DocHub can help you optimize the amount of time you need to spend on document modifying no matter your prior experience with such tools. Create an account now and increase your productivity instantly with DocHub!
you can use worksheet outlines to create summary reports that dont show all the details the example worksheet shows the number of units manufactured by a company in each month from 2014 you can see there are subtotals calculated for each quarter using formulas you can add outline to this worksheet data so that you can expand or collapse detailed data for each quarter to create the outline move the cell pointer anywhere in the range of data click on data click on group click on auto outline you can see a section added by Excel on left side which has controls which allows to collapse certain data in the range click on controls you can see you can suppress the specific quarter details and only display the subtotal for the quarter or you can display only the grand total you can also see the controls one two three at the top which allows to display details or subtotals or grand total for the data if you click on two it shows only the subtotals click on one it shows only the grand total if
