1cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 2cdf0e10cSrcweir 3cdf0e10cSrcweir 4cdf0e10cSrcweir 5*02dbb15cSAndrew Rist<!--*********************************************************** 6cdf0e10cSrcweir * 7*02dbb15cSAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 8*02dbb15cSAndrew Rist * or more contributor license agreements. See the NOTICE file 9*02dbb15cSAndrew Rist * distributed with this work for additional information 10*02dbb15cSAndrew Rist * regarding copyright ownership. The ASF licenses this file 11*02dbb15cSAndrew Rist * to you under the Apache License, Version 2.0 (the 12*02dbb15cSAndrew Rist * "License"); you may not use this file except in compliance 13*02dbb15cSAndrew Rist * with the License. You may obtain a copy of the License at 14*02dbb15cSAndrew Rist * 15*02dbb15cSAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 16*02dbb15cSAndrew Rist * 17*02dbb15cSAndrew Rist * Unless required by applicable law or agreed to in writing, 18*02dbb15cSAndrew Rist * software distributed under the License is distributed on an 19*02dbb15cSAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 20*02dbb15cSAndrew Rist * KIND, either express or implied. See the License for the 21*02dbb15cSAndrew Rist * specific language governing permissions and limitations 22*02dbb15cSAndrew Rist * under the License. 23*02dbb15cSAndrew Rist * 24*02dbb15cSAndrew Rist ***********************************************************--> 25*02dbb15cSAndrew Rist 26*02dbb15cSAndrew Rist 27cdf0e10cSrcweir 28cdf0e10cSrcweir 29cdf0e10cSrcweir <helpdocument version="1.0"> 30cdf0e10cSrcweir<meta> 31cdf0e10cSrcweir<topic id="textscalcguidesorted_listxml" indexer="include" status="PUBLISH"> 32cdf0e10cSrcweir<title xml-lang="en-US" id="tit">Applying Sort Lists</title> 33cdf0e10cSrcweir<filename>/text/scalc/guide/sorted_list.xhp</filename> 34cdf0e10cSrcweir</topic> 35cdf0e10cSrcweir</meta> 36cdf0e10cSrcweir<body> 37cdf0e10cSrcweir 38cdf0e10cSrcweir 39cdf0e10cSrcweir 40cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3150870"><bookmark_value>filling;customized lists</bookmark_value> 41cdf0e10cSrcweir<bookmark_value>sort lists;applying</bookmark_value> 42cdf0e10cSrcweir<bookmark_value>defining;sort lists</bookmark_value> 43cdf0e10cSrcweir<bookmark_value>geometric lists</bookmark_value> 44cdf0e10cSrcweir<bookmark_value>arithmetic lists</bookmark_value> 45cdf0e10cSrcweir<bookmark_value>series;sort lists</bookmark_value> 46cdf0e10cSrcweir<bookmark_value>lists; user-defined</bookmark_value> 47cdf0e10cSrcweir<bookmark_value>customized lists</bookmark_value> 48cdf0e10cSrcweir</bookmark> 49cdf0e10cSrcweir <comment>mw deleted "applying;"</comment> 50cdf0e10cSrcweir <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> 51cdf0e10cSrcweir</variable></paragraph> 52cdf0e10cSrcweir <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> 53cdf0e10cSrcweir <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> 54cdf0e10cSrcweir <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> 55cdf0e10cSrcweir <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> 56cdf0e10cSrcweir <section id="relatedtopics"> 57cdf0e10cSrcweir 58cdf0e10cSrcweir <embed href="text/scalc/guide/calc_series.xhp#calc_series"/> 59cdf0e10cSrcweir <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> 60cdf0e10cSrcweir 61cdf0e10cSrcweir </section> 62cdf0e10cSrcweir </body> 63cdf0e10cSrcweir</helpdocument> 64