9-8-2

Using Memory in the S SHT Mode

kSaving 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).

uTo save the contents of a range of cells to List Memory1.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 configuration 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.

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

 

 

 

File6

 

List1

 

List2

 

List3

1

 

2

 

3

 

 

 

 

4

 

5

 

6

 

7

 

8

 

9

Spreadsheet

 

File Memory

 

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

20070201