Sort sheets

Sheet > Sort sheets

If you have a lot of sheets in a workbook, it is sometimes easier to arrange them in alphabetical order. However, Excel does not have a built-in option to sort sheets. You can only do this by dragging and arranging the sheets manually. But this can be time-consuming and it is also not fun.

Luckily, we have a tool for this. With this utility, you can sort the sheets in your workbook.

You can sort sheets in either ascending or descending order.

Screenshot

Before sorting:

After sorting:

Running this tool

Click YLC Utilities > Sheet > Sort sheets :

Do you recognize any of these situations?

• I have a sheet. Excel for each employee. How to sort all these sheets alphabetically?
• Is it possible to sort all sheets in a workbook and if so, how do I do it?
• How to arrange tabs in Excel in alphabetical order? I have a large list of clients. Their information is placed in separate tabs Excel . How can I arrange these tabs alphabetically without having to drag and drop the tabs manually?
• I have a lot of worksheets but now the client wants them in a different order to save time, is there any way I can do this? Excel can re-sort them alphabetically.

Quick solution

Just use the next tool in the menu Excel :

YLC Utilities » Sheet » Sort sheets

This is a faster solution than manually dragging sheet tabs.

How much time will this save?

Using this tool will definitely save you time and effort. However, the actual time savings will depend on how often you use it. Excel , the amount of data you work with, and how often you use this tool.

Download extension

You can use the utility Sort sheets by installing the extension YLC Utilities .

After that, this function will be available in all files that are opened in Excel .