How to Sort Sheets/Worksheets Alphabetically in Excel Office 365?
Tags: kutoolsexceltutorial, sortsheetsworksheets, kutools
Published: 2020-11-24 09:28:31

---
title: How to Sort Sheets/Worksheets Alphabetically in Excel Office 365?
published: true
date: 2020-11-24 08:21:16 UTC
tags: KutoolsExcelTutorial,SortSheetsWorksheets,Kutools
canonical_url: https://geekexcel.com/how-to-sort-sheets-worksheets-alphabetically-in-excel-office-365/
---

In this article, we are going to see how to **Sort Sheets/Worksheets Alphabetically in Excel Office 365** with **Kutools.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Sort Sheets Alphabetically:

To sort [Sheets](https://geekexcel.com/how-to-use-excel-sheets-function-in-office-365-with-examples/) in alphabetical order in Excel, do as following steps.

- [Open the workbook](https://geekexcel.com/open-a-workbook-using-shortcut-in-excel-365/) that contains multiple sheets which you want to arrange them.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-42.png)<figcaption id="caption-attachment-17988">Example</figcaption>

- On the **Kutools Plus Tab, select** the **Worksheet** option, then **choose** the **Sort Sheets** option from the menu.

![Select Sort Sheets option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-Sort-Sheets-option.png)<figcaption id="caption-attachment-17989">Select Sort Sheets option</figcaption>

- Then, it will open the **Sort Sheets Dialog Box**.
- You need to click the **Alpha Sort** button.
- You can also see the **preview results** in the **New sheet tabs order** list box.
- Then, **hit** the **OK** button.

![Sort Sheets Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Sort-Sheets-Dialog-Box.png)<figcaption id="caption-attachment-17990">Sort Sheets Dialog Box</figcaption>

- Finally, you can see that the sheet tabs are sorted in alphabetical order as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Result-21.png)<figcaption id="caption-attachment-17991">Result</figcaption>

### Note:

- **Original sheet tabs order –** It will show **all the sheet tabs** of the current workbook.
- **New sheet tabs order –** This section will display the **preview** results.
- **Alpha Sort –** It will sort sheets/worksheets **alphabetically.**
- **Move up/Move down –** These buttons are used to **change specific sheets tabs** manually in the **New sheet tabs order** list.
- **Reverse –** The sheet tab order will be reversed in the **New sheet tabs order** list.
- **View sheet –** If you check this option, it will **activate the sheet** in the workbook when you click the sheet in the  **New sheet tabs order** list.
- **Reset –** The new sheet tabs order will be restored to the original state.

## Arrange Sheets/Worksheets Alphanumerically:

If you need to arrange sheets alphanumerically, then follow the below steps.

- First, you need to [open the workbook](https://geekexcel.com/open-a-workbook-using-shortcut-in-excel-365/) that you want to [sort](https://geekexcel.com/how-to-sort-data-randomly-in-excel-office-365-with-examples/) sheets alphanumerically.

![Open the workbook](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-41.png)<figcaption id="caption-attachment-17992">Open the workbook</figcaption>

- Go to the **Kutools Plus Tab, select** the **Worksheet** option, then **choose** the **Sort Sheets** option from the menu.

![Select Sort Sheets option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-Sort-Sheets-option.png)<figcaption id="caption-attachment-17989">Select Sort Sheets option</figcaption>

- Then, it will open the **Sort Sheets Dialog Box**.
- You need to **click** the **Alpha Numeric Sort** button.
- Then, you can preview the results in the **New sheet tabs order** list.
- Finally, **hit** the **OK** button.

![Hit the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/3-40.png)<figcaption id="caption-attachment-17993">Hit the OK button</figcaption>

- The sheets have been sorted in alphanumerical order as shown in the below screenshot.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/4-36.png)<figcaption id="caption-attachment-17994">Output</figcaption>

### Note:

- **Original sheet tabs order –** It will show **all the sheet tabs** of the current workbook.
- **New sheet tabs order –** This section will display the **preview** results.
- **Alpha-Numeric Sort –** It will sort sheets/worksheets **alphanumerically**.
- **Move up/Move down –** These buttons are used to **change specific sheets tabs** manually in the **New sheet tabs order** list.
- **Reverse –** The sheet tab order will be reversed in the **New sheet tabs order** list.
- **View sheet –** If you check this option, it will **activate the sheet** in the workbook when you click the sheet in the  **New sheet tabs order** list.
- **Reset –** The new sheet tabs order will be restored to the original state.

## Sort Sheets by Tab Color:

You can also sort sheets by their tab color in Excel. To do this, follow the below steps.

- **Open the workbook** that contains colored sheet tabs as shown in the below image.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/5-31.png)<figcaption id="caption-attachment-17995">Example</figcaption>

- On the **Kutools Plus Tab, select** the **Worksheet** option, then **choose** the **Sort Sheets** option.

![Select Sort Sheets option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-Sort-Sheets-option.png)<figcaption id="caption-attachment-17989">Select Sort Sheets option</figcaption>

- It will open the **Sort Sheets Dialog box**.
- Next, you need to **click** the **Color Sort** button.
- You can see the **preview results** in the **New sheet tabs order** list.

![Click OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/6-29.png)<figcaption id="caption-attachment-17997">Click OK button</figcaption>

- Then, you need to **click** the **OK** button. You can see that the sheet tabs arranged by tab colors as shown in the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/7-27.png)<figcaption id="caption-attachment-17999">Output</figcaption>

### Note:

- **Original sheet tabs order –** It will show **all the sheet tabs** of the current workbook.
- **New sheet tabs order –** This section will display the **preview** results.
- **Color Sort –** It will sort sheets/worksheets by the **tab colors**.
- **Move up/Move down –** These buttons are used to **change specific sheets tabs** manually in the **New sheet tabs order** list.
- **Reverse –** The sheet tab order will be reversed in the **New sheet tabs order** list.
- **View sheet –** If you check this option, it will **activate the sheet** in the workbook when you click the sheet in the  **New sheet tabs order** list.
- **Reset –** The new sheet tabs order will be restored to the original state.

## Bottom-Line:

In this article, you can easily understand the steps to **Sort Sheets/Worksheets Alphabetically in Excel Office 365** with **Kutools.** Kindly, share your **queries/feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [Encrypt & Decrypt Selected Cell Values/Contents In Excel 365!!](https://geekexcel.com/encrypt-decrypt-selected-cell-values-contents-in-excel-365/)
- [How to Sort Data by Last Name/Month/Frequency/Text Length in Excel?](https://geekexcel.com/how-to-sort-data-by-last-name-month-frequency-text-length-in-excel/)