Using Selection ListsIf you do a lot of repetitive text entry in spreadsheets, and you don't want to use AutoInput (previous section), you can use selection lists to select text you've entered previously.
If you don't get a selection list, the column may contain data that's too varied. Setting Up Sort ListsCalc makes filling in cell information easy and automatic by using the automatic fill feature (see Filling to Increment Data on page 531). The idea is to type one piece of information in a cell, select the cell, and drag the little square in the lower right corner of the cell in any direction to fill in a consecutive list of items. For example, say you want to track sales in your organization's five biggest cities, and you either want to list those cities in regional order (or you don't want to have to type each one in manually in every spreadsheet you create). Set up a sort list for those cities so that when you enter one city name , you can use automatic fill to enter the names of the remaining cities, as shown in Figure 19-3. Figure 19-3. A sort list of cities
Adding a Sort List
When you do an automatic fill for the sort list, dragging to the left or up fills in cells with the values that precede the one you entered. Note You can also enter a new sort list by selecting a range of cells in Calc, opening the Sort List options window, clicking the Copy button, and clicking OK (see Figure 19-5). Figure 19-5. Copying a sort list from the spreadsheet
You don't have to set up sort lists for numbering or dates. Calc knows how to handle those already. Modifying a Sort List
Deleting a Sort List
|