When you want to apply a small tweak to the document, it should not take long to Group columns attestation. This type of simple activity does not have to require additional education or running through guides to learn it. With the proper document editing instrument, you will not spend more time than is necessary for such a swift edit. Use DocHub to simplify your editing process regardless if you are a skilled user or if it’s your first time making use of a web-based editor service. This instrument will take minutes to learn how to Group columns attestation. The only thing required to get more productive with editing is actually a DocHub account.
A plain document editor like DocHub will help you optimize the time you need to spend on document editing irrespective of your previous experience with this kind of resources. Create an account now and improve your efficiency immediately with DocHub!
A lot of times when youre using a spreadsheet, you have lists of data and you have subgroups and you might even have a total for all of it. But you really dont want to show whats in between. If thats the case, a great way to solve this is by using groups and subgroups and Im gonna show you how to do that. The data that we have is already subtotaled. If you look in the formula box, it uses SUBTOTAL and with function number 9. I did it that way instead of summing it because when you come down at the bottom and you do the SUBTOTAL again, it doesnt pick up all these other subtotals so it doesnt count them. I want to leave these rows exposed when I do my grouping so I want to hide this data, but I want to have first quarter, second quarter, third, etc. showing. Thats how I want to present it. Lets get rid of this data from your view but lets leave it in the formulas. Lets highlight all the rows that we want to get rid of. Notice I didnt highlight the header row and I did not hi