How to ungroup worksheets in Excel (with Video Guide)

Grouping in Excel gives you great convenience. You can instantly apply your work in a single spreadsheet to the rest grouped sheets. This saves you a lot of time since you don’t have to repeat …

Grouping in Excel gives you great convenience. You can instantly apply your work in a single spreadsheet to the rest grouped sheets. This saves you a lot of time since you don’t have to repeat the same tasks over and over. Once you have done your job, now you want to ungroup them. How?

This post explains how you can ungroup worksheets in Excel.

How to ungroup worksheets

Ungrouping in Excel is straightforward. If you were able to group them, you should be able to ungroup them too.

  1. Press Ctrl key and select the worksheets you want to ungroup.
  2. By this method, you can ungroup all or specific worksheets.

If you want to ungroup all worksheets once, there is a faster way.

  1. Right-click any of the grouped sheet.
  2. On the pop-up window, select “Ungroup Sheets”

That’s it. You can easily test it by type random words in the spreadsheet you worked and check the rest.

Video Guide

If you’re unsure how to do this, check this video guide.

Grouping options you may not know

When you want to group them back, try these ways. There is more than one option to group spreadsheets. Learning these can help you to save more time.

Select and group

If you want to select specific spreadsheets for grouping, you can follow the steps.

  1. Press Ctrl key and select the worksheets you want to group.
  2. Go to the sheet you want to work and check if the same gets applied to the selected.

Group all sheets

If you want to group all spreadsheets at once, there is an easier way.

  1. Right-click any spreadsheet.
  2. Choose “Select All Sheets”
    • Note that when you use this option, the grouping will be canceled when you click any of the grouped sheets. You can go check other grouped spreadsheets when you don’t group all sheets.

Group continuous sheets

If you want to group continuous sheets, try this.

  1. Click the first spreadsheet you want to group.
  2. Press and hold shift key.
  3. Click the last spreadsheet you want to group.

You will be able to see all the sheets in between are grouped.

Wrapping up

Grouping and ungrouping save you time and efforts that could have been spent for repetitive work. These methods are easy to follow. For grouping, however, you will need to make sure the structures of the sheets are identical. You can add the same contents and same formula.