beautypg.com

Casio SERIES FX-9860G User Manual

Page 495

background image

20070201

9-8-2

Using Memory in the S

SHT Mode

k Saving Spreadsheet Data to List Memory

You can use the following procedure to select a series of cells in a particular column or row
and save their data to List Memory (List 1 through List 26).

u To save the contents of a range of cells to List Memory

1. Select the range of cells whose data you want to save in List Memory.

• You can select a series of cells in a column or a series of cells in a line. Selecting any

other confi guration of cells will cause an error.

2. Press

6(g)3(STO)2(LIST).

• The “Cell Range” setting will show the range of cells

you selected in step 1.

3. Press

c to move the highlighting to “List [1~26]”.

4. Enter a list number in the range of 1 to 26, and then press

w.

5. Press

6(EXE) or the w key to save the data in the List Memory.

• If the List Memory you select already has data assigned to it, the new data will replace

the existing data.

k Saving Spreadsheet Data to File Memory

You can use the following procedure to select a range of cells and save their data to File
Memory (File 1 through File 6). Data is saved sequentially from left to right, line by line, and
each column is saved as a File Memory list (List 1 through List 26).

The following shows how spreadsheet data in the range of A1:C3 is saved to File 6.

Spreadsheet

File

Memory

File6

List2

List3

List1

2

3

1

5

6

4

8

9

7

File6

List2

List3

List1

2

3

1

5

6

4

8

9

7

# The value in any cell that is empty, contains

text, or has ERROR displayed is changed
to 0 when you perform step 5 of the above
procedure.