Explainry Tutorials to Expert in IT

Group Worksheets in Excel

You can save a lot of time by performing tasks in different worksheets at the same time by group worksheets feature, this technique works well if you have an identical data structure in all worksheets.

1. To group different worksheets, keep holding Ctrl button and click on the tab of a worksheet that you want to group.

2. Each worksheet has the same data structure, suppose you want to calculate sale for the month of Jan of each city. As all sheets have been grouped, any change will occur on all worksheets, for example, we implement the sum formula in Jan column of City1, any change to the City1 worksheet is automatically made to other worksheets:

3. To ungroup worksheets, do the following steps:

  • Right click on any worksheet tab in the group.
  • Click Ungroup Sheets.

Copyright © 2016 - 2020 Explainry.com | All Rights Reserved