Frequently asked questions - Calc

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

• Wiki Home
• Development
• Design
• QA
• Events
• Documentation
• Website
• Localization
• Accessibility
• Marketing
• Diversity
• Wiki Help

• Documentation Home
• Official Publications
• Other Resources
• FAQ
• HowTo
• Macros
• Docs Development

• FAQ Home
• General
• Writer
• Calc
• Impress
• Draw
• Math
• Base

How do I create my own sort lists?

Calc has a particularly useful trick. When, for example, you write a day of the week and then drag the handle at the bottom right of the cell, the other days of the week are written automatically into the following cells.

You can create your own personalized lists as follows:

1. Go to Tools ▸ Options ▸ LibreOffice Calc ▸ Sort lists
2. Click on the New button.
3. In the Entries area, type the words that will form your list, separated by the ↵ Enter key.
4. When the list is complete, confirm by clicking OK.

Another faster method:

1. In an open spreadsheet, type the words of your list into adjacent cells.
2. Select the area containing the words.
3. Go to Tools ▸ Options ▸ LibreOffice Calc ▸ Sort Lists.
4. At the bottom of the window, the Copy list from should contain the coordinates of the selected area. If this is correct, accept the list by clicking Copy; if not, correct the coordinates before clicking the button.
5. Click OK.

Now you can type a word from your list and, when you drag the cell handle, the other elements will be copied, starting again from the beginning of the list where necessary.

The order of the words in your list can be used for sorting data:

1. Select the data to be sorted.
2. Open the Sort dialog by using Data ▸ Sort.
3. On the Options tab, check Custom Sort Order and choose the list you want.

If a list ceases to be useful, you can delete it :

1. Go to Tools ▸ Options ▸ LibreOffice Calc ▸ Sort Lists
2. Click on the list to be deleted.
3. Click the Delete button.
4. Confirm the deletion and then click OK.