Casio FX-9860G kSorting Spreadsheet Data, uTo sort spreadsheet data, kDeleting and Inserting Cells, uTo delete an entire line or column of cells

9-4-19

Inputting and Editing Cell Data

kSorting 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.

uTo 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.

kDeleting 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.

uTo 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	# A “Syntax ERROR” will occur if the data you are
line or a single column of data. Attempting to	trying to sort contains a formula or text.
perform a sort operation when multiple lines
or multiples columns are selected will cause a
“Range ERROR”.

20070201