# 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.

## 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.

`=D5<6000`

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.

• 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

<< Go Back to Excel Worksheets | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Lutfor Rahman Shimanto

Lutfor Rahman Shimanto, BSc, Information Technology, Jahangirnagar University, Bangladesh, has worked with the ExcelDemy project for over a year. He has written 50+ articles and provided solutions of 100+ comments for ExcelDemy. Currently, he works as an Excel & VBA Developer and provides support and solutions in the ExcelDemy Forum. He has solved 100+ ExcelDemy Forum problems. His work and learning interests are in developing various Excel & VBA and Desktop applications. Outside of work, he enjoys Chess... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF