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.

Organize Sheets in Excel according to alphabetical order

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.

Select intended cells to apply shortcut

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


New Formatting Rule window

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

Format Cells Window

Thus, the output will look like the below one.

Output of applying shortcuts to organize sheets by highlighting cells in Excel

Example 2: Change Sheet Tab Color in Excel

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

organize sheets by Changing Sheet Tab Color in Excel

How to Sort Worksheets Alphabetically

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

Before Sorting Alphabetically

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

Code to organize sheets in alphabetical order

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

Organize sheets by Sorting Alphabetically in Excel

How to Group Worksheets in Excel

Example 1: Group Selected Sheets

Hold down the Ctrl key and select the intended sheets.

Select intended sheets to group

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

Run VBA code to Group Selected Sheets

Thus, we will see the output like the following.

Output of grouping selected sheets

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

Run VBA code to group all sheets

Thus, the output will look like the below one.

Output of grouping all sheets

How to Ungroup Worksheets in Excel

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

Apply no color to sheet tab

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

Ungroup Sheets

How to Delete Sheets in Excel

Example 1: Delete a Sheet

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

Delete a sheet

Example 2: Delete Selected Sheets

Right-click on selected sheets >> choose Delete.

Delete selected sheets

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.


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

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

Leave a reply

Advanced Excel Exercises with Solutions PDF