Thank you for subscribing!

It's great to feel loved.

How to Group Worksheets in Microsoft Excel

What if you want to write the same data, make the same changes or apply the same action at multiple worksheets at the same time in Excel? Microsoft Excel makes it easy to group worksheets, and you do not have to waste your time and work on them individually.

Grouping multiple sheets in Excel is a convenient way of applying the same action in more than one worksheet at the same time. After you are finished reading this article, you will easily group worksheets and then edit, or add standard features such as header, footer to all of them, at the same time.

How to Group Worksheets in Excel

In case you want to make the same changes in three different sheets. Instead of doing it individually, you may group the sheets, and when you edit one sheet, you will see other selected sheets are automatically edited.

Open Microsoft Excel and choose the sheets you want to group together:

   
  • Select a sheet;
  • Then hold down the CTRL key if you are on windows or hold the command key if you are working on Mac;
  • Now click on all the other sheets you want to group together.

How to Select All the Sheets in the Workbook

  • If you want to select all worksheets, right-click on a sheet and select all sheets;
  • Make sure you see the group written in the bracket in your title bar at the top so that you know you are working in a group of worksheets;
  • Be careful and do not click on a sheet which is not in the group, or doing so will ungroup all selected worksheets.

When you have selected the sheets, you want to work in a group, whatever you write, change or apply on one sheet, will appear on every selected sheet in the group.

For example, now that you have selected the sheets, you may insert a Header. You can see the header is applied at the same place in every selected worksheet. Likewise, you can add a footer, or write anything you want to appear on all of your selected sheets.

How to Ungroup Worksheets in Excel

After you are done editing your sheets, you can right-click on the sheet you want to remove from the group and then click on the ungroup sheets option. Another easier way to ungroup sheets is to click on any unselected sheet, and all the sheets will be ungrouped.

Grouping worksheets in Excel is a simple and straightforward feature. Lastly, make sure to check if your sheets are in a group or separate before you start working on individual worksheets. In case you want to make specific data reports try Excel integration with Whatagraph to see how it may be done in a faster way.

Safe time in your reporting

Mike Bennet
Written By Mike Bennet
whatagraph
How to Make a Scatter Plot in Microsoft Excel
Scatter graph is another word for scatter plot and they are related to line graphs. A scatter plot uses dots for the representation of data pieces while line graphs just use lines X and Y. Statistically, scatter plots are used to identify if two variables are related in any way. For this reason, you need to know how to do a scatter plot in Excel.
whatagraph
How to Edit Legend in Microsoft Excel
Excel is a software that permits its users to organize and calculate data with multiple formulas using a spreadsheet. Microsoft Excel aids users create charts that are meaningful to visualize their spreadsheet data by automatically inferring some of the chart elements. What about Legends?
whatagraph
Best Microsoft Excel Alternatives
Excel is an important tool in everyday life. It entails various features that help in storing information, arrangement, and processing. It is an app specialised in project management and data analysis. But then Excel has been far overhyped in its functions and tasks can be carried out by other Excel alternatives.
Zoom and GoToMeeting are two of the most popular and reliable video conferencing solutions today, so we’ve made Zoom vs GoToMeeting summary to compare them and see which of them fits your business needs best.
Read more...
Mike Bennet
Jun 02, 2020 6 min read
Even though both tools are great, they do differ in certain aspects, and in order to find out the right one for you, you need to understand what Hootsuite and Buffer actually do and compare their common features and pricing.
Read more...
Mike Bennet
Jun 02, 2020 6 min read
In this in-depth HubSpot vs Salesforce comparison, we’ll break down some of their key features to help you make the right decision.
Read more...
Wendy Gooseberry
Jun 01, 2020 5 min read