Brother International PDP350CJ Owner's Manual - English - Page 207

Sorting Be sure to save your work before you perform a sort. Then, if the results of the sort are not what you expected, you can choose Other from the File menu and then choose Discard Changes from the Other submenu. You can sort information in a row, column, or range of cells in either alphabetical (A-Z) or numeric (1-9) order. In addition, you can sort in either ascending (A-Z and 1-9) or descending (Z-A and 9-1) order. A range is sorted by the row or column containing the active cell. For example, you may be keeping track of the payments of a group of piano students. As shown in the illustration below, you can alphabetize the list of names and the payments. Select the range of cells containing all the names and payment information, being certain that the list you want to alphabetize is the leftmost column in the selection. Then, when you sort the list alphabetically, the names (and the payments for that student) are shown in alphabetical order. Unsorted SISz ue uas kni ei OI Jwo G na ema sr aa i N 22o 55 P 00a 00y m e n t N 22 o55 P 00 a00 y m e n t Sorted ISSz ue uas kni ei OI Jwo G na ema sr aa i N 22o 55 P 00a 00y m e n t N 22 o55 P 00 a00 y m e n t Only data in the unlocked areas is sorted when using the Sort feature. Data in the locked titles is not reorganized. Spreadsheet will sort all selected cells by the row or column containing the active cell. "To sort information in a spreadsheet: 1. Select the cells containing the information you want to sort. Be sure to select all the cells you want to sort. 2. If the active cell is not in the row or column you want to sort, move it with one of the following keystrokes: S RETURN. Moves the active cell down one row. S SHIFT + RETURN. Moves the active cell up one row. S TAB. Moves the active cell right one column. S SHIFT + TAB. Moves the active cell left one column. 3. Choose Sort from the Edit menu. A dialog box appears: 4. Fill in the dialog box, specifying the sort criteria you want to use: S Sort By. You can sort either rows or columns. S Sort Order. You can sort in either Ascending or Descending order: for example, A, B, C, D or Z, Y, X, W. Spreadsheet 193