Working with multiple worksheets in an Excel 2013 workbook makes it easy to keep related information in one convenient location. But occasionally you will need to update the same field, or make the same formatting change, to many worksheets at the same time, which can be tedious to do to each individual sheet.
One way that you can improve this situation is to group your worksheets. When multiple worksheets are grouped together, you can perform an action on one of the sheets and apply that action to each of the other grouped sheets as well.
Make a Worksheet Group in Excel 2013
The steps in this article will show you how to create a group of worksheets in your Excel 2013 workbook. If you save a workbook with a worksheet group, then those worksheets will still be grouped when you go to open the workbook later. If you click an ungrouped worksheet after following the steps below to group your worksheets, then it will remove the grouping effect.
- Open the workbook containing the worksheets that you want to group.
- Click the first worksheet tab that you want to include in the group.
- Hold down the Ctrl key on your keyboard, then click each other worksheet that you want to include in the group. I have grouped Sheet1, Sheet2 and Sheet3 in the image below. You will know that your worksheets are grouped when they are highlighted in white, and when the word [Group] is shown next to the file name at the top of the window.
You can then add data to a cell in one of the worksheets, or change the formatting on the worksheet, and it will apply to each of the other worksheets in the group. Note that certain actions cannot be applied to grouped worksheets, such as setting titles or print areas.
Are there row numbers and column letters that are printing with your worksheet? Learn how to stop printing headings in Excel 2013 if you don’t want to include this information on your printouts.