Casio CFX-9850GB PLUS, User Manual

Page: 492 / 600

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.