For example, if you make a spreadsheet with five worksheets listing your monthly expenses (e. g. , January, February, and March, April, May), you could select January and March to group them. Once the worksheets are grouped, any changes you make to one worksheet will apply to all worksheets in the group. For example, if you create a subtraction formula in the January worksheet, the same formula will appear in the March worksheet.
Hold down Ctrl (Windows) or ⌘ Cmd (Mac). Click the tabs of each worksheet you want to remove.
Use this method to group every worksheet in the current workbook. For example, if you have five worksheets listing your monthly expenses (e. g. , January, February, March, April, May), this method will group all five months together so you can quickly make changes to all months at once.
Any edit you make to a worksheet in the group will be applied to every worksheet. For example, if you create a summation formula in the January worksheet, the formula will be applied to the other five months as well. The grouping feature is especially helpful for quickly applying complex functions (like VLOOKUP) to multiple worksheets.
Right-click the tab for any worksheet in the group. Select Ungroup Sheets.
