1cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 2cdf0e10cSrcweir 302dbb15cSAndrew Rist<!--*********************************************************** 4bc4ff2acSmseidel * 502dbb15cSAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 602dbb15cSAndrew Rist * or more contributor license agreements. See the NOTICE file 702dbb15cSAndrew Rist * distributed with this work for additional information 802dbb15cSAndrew Rist * regarding copyright ownership. The ASF licenses this file 902dbb15cSAndrew Rist * to you under the Apache License, Version 2.0 (the 1002dbb15cSAndrew Rist * "License"); you may not use this file except in compliance 1102dbb15cSAndrew Rist * with the License. You may obtain a copy of the License at 12bc4ff2acSmseidel * 1302dbb15cSAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 14bc4ff2acSmseidel * 1502dbb15cSAndrew Rist * Unless required by applicable law or agreed to in writing, 1602dbb15cSAndrew Rist * software distributed under the License is distributed on an 1702dbb15cSAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 1802dbb15cSAndrew Rist * KIND, either express or implied. See the License for the 1902dbb15cSAndrew Rist * specific language governing permissions and limitations 2002dbb15cSAndrew Rist * under the License. 21bc4ff2acSmseidel * 2202dbb15cSAndrew Rist ***********************************************************--> 2302dbb15cSAndrew Rist 24bc4ff2acSmseidel<helpdocument version="1.0"> 25cdf0e10cSrcweir<meta> 26cdf0e10cSrcweir<topic id="textscalcguidesorted_listxml" indexer="include" status="PUBLISH"> 27cdf0e10cSrcweir<title xml-lang="en-US" id="tit">Applying Sort Lists</title> 28cdf0e10cSrcweir<filename>/text/scalc/guide/sorted_list.xhp</filename> 29cdf0e10cSrcweir</topic> 30cdf0e10cSrcweir</meta> 31cdf0e10cSrcweir<body> 32*1832f669Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3150870"> 33*1832f669Smseidel<bookmark_value>filling;customized lists</bookmark_value> 34cdf0e10cSrcweir<bookmark_value>sort lists;applying</bookmark_value> 35cdf0e10cSrcweir<bookmark_value>defining;sort lists</bookmark_value> 36cdf0e10cSrcweir<bookmark_value>geometric lists</bookmark_value> 37cdf0e10cSrcweir<bookmark_value>arithmetic lists</bookmark_value> 38cdf0e10cSrcweir<bookmark_value>series;sort lists</bookmark_value> 39cdf0e10cSrcweir<bookmark_value>lists; user-defined</bookmark_value> 40cdf0e10cSrcweir<bookmark_value>customized lists</bookmark_value> 41cdf0e10cSrcweir</bookmark> 42bc4ff2acSmseidel<comment>mw deleted "applying;"</comment> 43bc4ff2acSmseidel<paragraph xml-lang="en-US" id="hd_id3150870" role="heading" level="1" l10n="U" oldref="3"><variable id="sorted_list"><link href="text/scalc/guide/sorted_list.xhp" name="Applying Sort Lists">Applying Sort Lists</link> 44cdf0e10cSrcweir</variable></paragraph> 45bc4ff2acSmseidel<paragraph xml-lang="en-US" id="par_id3159154" role="paragraph" l10n="U" oldref="7">Sort lists allow you to type one piece of information in a cell, then drag it to fill in a consecutive list of items.</paragraph> 46bc4ff2acSmseidel<paragraph xml-lang="en-US" id="par_id3148645" role="paragraph" l10n="U" oldref="4">For example, enter the text "Jan" or "January" in an empty cell. Select the cell and click the mouse on the lower right corner of the cell border. Then drag the selected cell a few cells to the right or downwards. When you release the mouse button, the highlighted cells will be filled with the names of the months.</paragraph> 47bc4ff2acSmseidel<paragraph xml-lang="en-US" id="par_id2367931" role="paragraph" l10n="NEW">Hold down <switchinline select="sys"><caseinline select="MAC">Command </caseinline><defaultinline>Ctrl </defaultinline></switchinline>if you do not want to fill the cells with different values.</paragraph> 48bc4ff2acSmseidel<paragraph xml-lang="en-US" id="par_id3152577" role="paragraph" l10n="U" oldref="5">The predefined series can be found under <emph><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - %PRODUCTNAME Calc - Sort Lists</emph>. You can also create your own lists of text strings tailored to your needs, such as a list of your company's branch offices. When you use the information in these lists later (for example, as headings), just enter the first name in the list and expand the entry by dragging it with your mouse.</paragraph> 49bc4ff2acSmseidel<section id="relatedtopics"> 50bc4ff2acSmseidel<embed href="text/scalc/guide/calc_series.xhp#calc_series"/> 51bc4ff2acSmseidel<paragraph xml-lang="en-US" id="par_id3147434" role="paragraph" l10n="U" oldref="6"><link href="text/shared/optionen/01060400.xhp" name="Sort lists">Sort lists</link></paragraph> 52bc4ff2acSmseidel</section> 53bc4ff2acSmseidel</body> 54cdf0e10cSrcweir</helpdocument> 55