content/documentation/faqs/spreadsheet/028.html

<meta http-equiv="REFRESH" content="10;url=http://wiki.services.openoffice.org/wiki/Documentation/FAQ">
<h3>This page is outdated. You will be redirected to <a href="http://wiki.services.openoffice.org/wiki/Documentation/FAQ">http://wiki.services.openoffice.org
/wiki/Documentation/FAQ</a> shortly.</h3>
<div style="margin-bottom: 10em;"></div>
<p><a href="../../index.html">Documentation</a> / <a
 href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
 href="027.html" accesskey="p">Previous</a>-<a href="029.html"
 accesskey="n">Next</a></p>
<h3>How can I create my own sort lists?
</h3>
<p>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.</p>
<p><b>To automatically fill data into cells from sort lists:</b></p>
<ol>
  <li>Insert a
day of the week, or other list item, into a cell.</li>
  <li>Next, select this cell, then drag the black square at the lower
right
corner across other cells in the same row or column.</li>
  <li>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.</li>
</ol>
<p><b>To create your own sort list:</b></p>
<ol>
  <li>Using the drop-down menu, go to <b>Tools &gt; Options</b>.</li>
  <li>In the left column expand <b>Spreadsheet</b> and go to <b>Sort
Lists</b>.</li>
  <li>In the pop-up window that will appear, select <b>New</b>.</li>
  <li>Under Entries, type your list, in the order you want, and
separate each word by a comma. Do not use spaces.</li>
  <li>When your list is complete, click <b>Add</b>.</li>
  <li>To learn more, click the <b>Help</b> button in the sort list
options box.</li>
</ol>
<p><a href="../../index.html">Documentation</a> / <a
 href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
 href="027.html" accesskey="p">Previous</a>-<a href="029.html"
 accesskey="n">Next</a></p>