Sort sheets

Sheet > Sort sheets...

If you have a lot of worksheets in a workbook, sometimes it's easier to put them in alphabetical order. However, LO Calc itself does not have a built-in option to sort sheets. This can only be done by manually dragging and arranging the sheets. But it can take a lot of time, and it's also not fun.

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

You can sort sheets in either ascending or descending order.

Screenshot

Before sorting:

After sorting:

Launch this tool

Click YLC Utilities > Sheet > Sort sheets... :

Do you recognize any of these situations?

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

Quick solution

Just use the following tool in the LO Calc menu:

YLC Utilities » Sheet » Sort sheets...

This is a faster solution than manually dragging sheet tabs.

How much time will it save?

Using this tool, you are guaranteed to save time and effort. However, the actual time savings depends on how often you use LibreOffice Calc, the amount of data you work with, and how often you use the tool.

Download

If you don't already have YLC Utilities, you can download the free version "YouLibreCalc.oxt" or the full-featured version "YLC_Utilities.oxt" .