Organize Sheets in Excel (Sort, Group, Ungroup Worksheets)

This article will cover many essential topics for Organize Sheets in Excel. You will also learn to insert multiple sheets, group and ungroup sheets. Moreover, we will walk you through sorting sheets alphabetically and deleting sheets.

Organizing sheets in Excel is essential to manage data more efficiently. It allows you to create separate sections for various data types, such as sales, expenses, or inventory.

After going through this context, you can improve your skills in organizing sheets in Excel. So, let’s dive in.

Download Practice Workbook

You can download the practice workbook by clicking the link below.

How to Organize Sheets in Excel

Example 1: Apply Shortcuts to Highlight Sheet

Select range B5:D9 >> press the Alt+H+L+N key.

Choose to Use a formula as Rule Type >> insert the below formula >> click on Format.

Later, go to Fill >> choose the desired color >> click on OK >> click OK again from New Formatting Rule.

Thus, the output will look like the below one.

Example 2: Change Sheet Tab Color in Excel

Right-click on the intended sheet tab >> click on Tab Color >> choose the desired color.

How to Sort Worksheets Alphabetically

To sort worksheets by name or alphabetically, press Alt+F11 to Open VBE.

Choose Insert >> click on Module >> type the below code and Run.

Sub SortTabsAlphabetically()

Dim ws As Worksheet
Dim i As Integer, j As Integer
Dim temp As Worksheet

Application.ScreenUpdating = False

For i = 1 To Worksheets.Count - 1

For j = i + 1 To Worksheets.Count

If UCase(Worksheets(j).Name) < UCase(Worksheets(i).Name) Then

Worksheets(j).Move before:=Worksheets(i)

End If

Next j

Next i

Application.ScreenUpdating = True

ThisWorkbook.Sheets("Sort Sheet Alphabetically").Activate

End Sub

As a result, we will see an output like the below one.

How to Group Worksheets in Excel

Example 1: Group Selected Sheets

Hold down the Ctrl key and select the intended sheets.

Later, click on Insert >> choose Module >> input the below code and Run.

Sub GroupSelectedSheets()

Dim ws As Worksheet

If ActiveWindow.SelectedSheets.Count < 2 Then

MsgBox "Please select two or more sheets to group.", vbInformation

Exit Sub

End If

For Each ws In ActiveWindow.SelectedSheets

ws.Tab.Color = RGB(0, 0, 255)

Next ws

End Sub

Thus, we will see the output like the following.

Example 2: Group All Sheets

Open VBE >> select Insert >> click on Module >> insert the below code and Run.

Sub GroupAllSheets()

Dim ws As Worksheet

For Each ws In ThisWorkbook.Sheets

ws.Select False

Next ws

For Each ws In ActiveWindow.SelectedSheets

ws.Tab.Color = RGB(0, 0, 255)

Next ws

End Sub

Thus, the output will look like the below one.

How to Ungroup Worksheets in Excel

Right-click on grouped sheet >> click on Tab Color >> choose No Color.

Later, right-click on group sheets again >> Choose Ungroup Sheets.

How to Delete Sheets in Excel

Example 1: Delete a Sheet

Right-click on the intended sheet >> choose Delete.

Example 2: Delete Selected Sheets

Right-click on selected sheets >> choose Delete.

Things to Remember

• Ensure there are no hidden sheets when grouping all sheets.
• Apply No-Color as the theme color to selected sheets, then Ungroup sheets.

Frequently Asked Questions

• How do you arrange sheets in order?

To arrange sheets in a specific order in Excel, click on a sheet tab and drag it to where you want it. Release the mouse button to drop the sheet in the new position. Repeat for other sheets to rearrange them as needed.

• How do I sort multiple sheets in Excel?

Typically we click on the sheet tab and drag a sheet to the intended place. We can implement Excel VBA code to sort multiple sheets at a time.

• How to organize tables in Excel?

To organize tables in Excel, give clear headers to each column. We can sort and filter data and freeze panes to keep titles visible. Sometimes we use conditional formatting to highlight important data.

Conclusion

We have covered many important topics for Organize Sheets in Excel. You have studied several practical ideas for organizing sheets. To learn more about Excel, please visit our ExcelDemy website. You can also discuss your Excel problem in our ExcelDemy Forum.

Organize Sheets in Excel: Knowledge Hub

• How to Arrange Excel Sheet in Ascending Order
• How to Sort Excel Sheet by Name 
• How to Reverse the Order of Worksheets in Excel 

<< Go Back to Excel Worksheets | Learn Excel