How to Ungroup Worksheets in Excel

Excel is a versatile program that uses loads of features to execute multiple functions. You can add, store and even calculate larger datasets containing numbers. Apart from that you can group or ungroup datasets in the worksheets to make the data accordingly.

Here you will learn how to ungroup worksheets in Excel by using different methods.

Why Ungroup Worksheets in Excel?

For repetitive tasks or formatting for some different sheets, need you to group the sheets. In case, when you have to make changes individually or when you need to overlook unwanted changes in data, you have to ungroup the sheets.

Easy and Fast Methods to Ungroup Worksheets in Excel

For a better understanding of how to ungroup worksheets in Excel, you will have to follow the methods given below. Using the following worksheet, you can see how we have ungrouped worksheets.

Ungroup All Worksheets Using Context Menu Bar

Using the Context Menu feature, you can ungroup the worksheets. For this, follow the steps given below:

1. First, place the mouse cursor in the grouped sheets and right-click to put the cursor on the Context Menu.
2. From this point, choose the Ungroup Sheets option.

All the grouped sheets here will be ungrouped.

Using CTRL Key to Ungroup Selected Worksheets

Using the CTRL key, you can ungroup the selected sheets. Let’s ungroup the grouped worksheets by following the steps given below:

1. First, press and hold the CTRL key from the keyboard.
2. Now, choose the particular sheet that is needed to be ungrouped.

Now, the grouped sheets are ungrouped.

Using SHIFT Key to Ungroup Worksheets

This method simply explains how you can use the SHIFT key to ungroup the grouped sheets. For this, follow the steps given below:

1. First of all, press and hold the SHIFT key from the keyboard.
2. Now, select adjacent or non-adjacent sheets.

3. In the end, you will see the grouped sheets are ungrouped.

Using Mouse Pointer Feature to Ungroup Worksheets

Using this method, you can ungroup all the worksheets easily. Let’s learn how you can execute this function using this feature:

1. Place the Mouse Cursor on any Adjacent Sheet.

2. Now, you can Ungroup All the Worksheets.

Using VBA to Ungroup All Worksheets

With the help of VBA coding, you can ungroup all the worksheets. For this, you have to save the Excel file in the .xlsm extension.

1. Firstly, choose the Developer tab and then open the Visual Basic option.

2. Choose Module from the Insert tab.

Put down the following code in the Module.

Option Explicit

Sub Ungroup_Worksheets ()

Sheets (“Dataset”).Select

End Sub

Now, you need to save the code and go back to Excel File.

From the Developer tab choose Macros.

Here, you will see the grouped worksheets are now ungrouped.

To Sum Up

Now, you have an idea about how to ungroup worksheets in Excel. You can try any of the methods mentioned above. Using the above methods, you can simply get the required results. Continue exploring Excel features and keep sharing useful hacks with others.