 In this training video, we're going to look at grouping worksheets in Microsoft Excel. So what this means is if worksheets are set up in the same way of working, so we've got 3D January here, we've got the heading fitness across to average sales, we've got sales types names Smith to Adams, and we've got some information from fitness to net profit and blank areas, the totals. When I look at the 3D February, it's the same, same four reps, different information, but the same setup, 3D March, again same four sales reps, different information, but the same setup. So this is the case and you've got many, many worksheets with the same setup and you wanted to make a change because what I want to do here is work at all the calculations for the totals, the averages and the percentage of fitness against total sales. So I wanted to do some calculations, but I don't want to do it three times. I don't want to do it for January, then have to do it for February again, and then have to do it for March again, because they're entirely the same worksheets with different information. So I want to do it once to apply to all three of them. You can do this by grouping worksheets together. So this is what we'll do here. So with 3D January selected as a worksheet, I'm now going to hold the shift key down and click on 3D March. Now this puts you into group mode. So you can see the worksheets go white down the bottom, and if you ever see white that means group mode. So that means whatever you do to one, you do to all three of them in this example. So I'm now going to put some calculations in for 3D January and then this will apply then for 3D February and 3D March. So I'm going to highlight at the net profit. I'm going to do another sum. Then I want the average. I'll use the average function here, and I want the average of fitness across to outdoor. Pull the average down. I don't want the total average. That doesn't make much sense. And I'll have the percentage of total sales in this fitness. So use fitness. Use total sales. So it's fitness divided by total sales. So equals the fitness for the sales rep divided by the total sales and I'm going to copy it down. So that's completed all the calculations for 3D January. I'm going to leave the merge at the top highlighted. So this now completes all the update for January with the formulas, percentages, averages. Well because it's grouped with 3D February and 3D March, this means these worksheets have also been completed. Now to one group to check the other worksheets. You can just right click on the worksheet. Any of the worksheets which are grouped. So I'm going to right click on 3D January. And I can see it says N group at the bottom. So N group takes you back to standard use of Excel where you're not in group mode. So I'm going to choose N group. The white goes away. You get the gray standard worksheet look back. So I'm going to check 3D February now and we can see all completed and 3D March all completed. So it's a very, very quick way of working. If you've got multiple worksheets which are all set up the same and then you want to produce some information or apply some information to however many worksheets you want to apply it to. So in this case you applied it to three. There could be a situation where there might be 20 worksheets which are all set up the same. So instead of you repeating it over and over 20 times by grouping whatever you do to one you do to the whole lot. This completes the training video on grouping worksheets together. Putting information in, seeing the change and then also and grouping worksheets. If you enjoyed this video make sure you like and subscribe to our channel. Hope to see you for the next tutorial and thanks for watching.