How can I create my own sort lists?

From Apache OpenOffice Wiki
< Documentation‎ | FAQ‎ | Calc‎ | Formatting
Jump to: navigation, search

How can I create my own sort lists?

Sometimes it is useful to use sort lists to control the order of your data, especially if the data is better sorted in an order that is not alphabetical or numerical.

Sort lists can be used to fill data into cells by "guessing" following values based on the value of a first cell. The most widespread example is the days of the week or names of the months:


  1. Insert "Jan" into a cell.
  2. Select this cell, then drag the black square at the lower right corner across other cells in the same row or column.
  3. The other names of the months will automatically fill into the selected cells.

To create your own sort list:

  1. Select Tools - Options from the menu.
  2. Click Calc and Sort Lists in the left column
    In 1.1.x, the option is called Spreadsheet instead of Calc.
  3. Click New on the right side of the window.
  4. Type your list in Entries box separating each word by a comma or a line break. Do not use spaces.
  5. Click Add after your list is complete to save your new sort list.

Personal tools