Casio FX-9860GII-L-IH User Guide - Page 474
Sorting Spreadsheet Data, Deleting and Inserting Cells, To delete an entire line or column of cells
View all Casio FX-9860GII-L-IH manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 474 highlights
9-4-19 Inputting and Editing Cell Data k Sorting Spreadsheet Data Spreadsheet data can be sorted column-wise or line-wise. You can select either ascending sort or descending sort. Important! • Sorting can be performed only when the selected range of cells contains all constants. u To sort spreadsheet data 1. Select the series of cells in a single row or a single column that you want to sort. • See "To select a range of cells" (page 9-3-4) for more information. 2. Use the function menu to select the type of sort you want to perform. Ascending: 2(EDIT)6(g)2(SRT•A) Descending: 2(EDIT)6(g)3(SRT•D) • Selecting a sort type will sort the data. k Deleting and Inserting Cells You can delete an individual cell, or an entire line or column of cells. You can also insert a line or column of blank cells when you need to. u To delete an entire line or column of cells 1. Select one or more cells inside the line(s) or column(s) you want to delete. This cell selection can be used to delete lines 1 and 2 or columns A and B. You could also select the entire line or column to be deleted. In this case, pressing 3(DEL) in step 2 below will instantly delete the entire line or column, without displaying the DEL submenu. 2. Press 3(DEL) to display the DEL submenu. # Data sorting is supported only for a single line or a single column of data. Attempting to perform a sort operation when multiple lines or multiples columns are selected will cause a "Range ERROR". # A "Syntax ERROR" will occur if the data you are trying to sort contains a formula or text. 20050401