The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.15

This page is outdated. You will be redirected to /wiki/Documentation/FAQ shortly.

Documentation / User FAQ / Calc / Previous-Next

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. Examples of this are the days of the week or the months of the year. Sort lists can be used to fill data into cells too.

To automatically fill data into cells from sort lists:

  1. Insert a day of the week, or other list item, into a cell.
  2. Next, 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 days of the week, or other items in the list related to the word chosen the first step will automatically fill into the selected cells.

To create your own sort list:

  1. Using the drop-down menu, go to Tools > Options.
  2. In the left column expand Spreadsheet and go to Sort Lists.
  3. In the pop-up window that will appear, select New.
  4. Under Entries, type your list, in the order you want, and separate each word by a comma. Do not use spaces.
  5. When your list is complete, click Add.
  6. To learn more, click the Help button in the sort list options box.

Documentation / User FAQ / Calc / Previous-Next

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache, OpenOffice, and the seagull logo are registered trademarks of The Apache Software Foundation. The Apache feather logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.