Casio FX-9750GII-SC User Guide - Page 275

Recalling Data from Memory to a Spreadsheet

Page 275 highlights

4. Input the List number (1 to 26) of the list memory where you want to store the data and then press U. • Performing the next step will overwrite any data currently stored under the list memory number you specified here with the data in the range of cells specified by "CellRange". 5. Press (EXE) or the U key to store the data. I Recalling Data from Memory to a Spreadsheet The following table shows an overview of the recall operations for each type of memory. For details about each operation, see the example operations following the table. Memory Type List Memory (List 1 ~ List 26) File Memory (File 1 ~ File 6) Matrix Memory (Mat A ~ Mat Z) Recall Operation You can recall data from a specified list memory to a range of cells in a single row or a single column. While the first cell of the range in a single row or single column is selected, press (E)(RCL)(LIST), and then specify the list number on the screen that appears. Whether the data is recalled in a column direction or row direction depends on the Setup screen's "Move" setting (page 1-29). You can recall data from a specified file memory to the spreadsheet. Select the cell you want to be the upper left corner of the recalled data and then press (E)(RCL)(FILE). Next, specify the file memory number on the screen that appears. You can recall data from a specified matrix memory to the spreadsheet. Select the cell you want to be the upper left corner of the recalled data and then press (E)(RCL)(MAT). Next, specify the matrix name on the screen that appears. S Example: To recall data from a matrix memory to a spreadsheet 1. On the spreadsheet, select the upper left cell of the range where you want the recalled data to be input. 2. Press (E)(RCL)(MAT). • This will display a screen like the one shown to the right. The "1st Cell" setting will show the name of the cell you selected in step 1. 3. Input the name (A to Z) of the matrix memory whose data you want to recall and then press U. 4. Press (EXE) or U to recall the data. Important! When recalling list memory, file memory, or matrix memory data, an error will occur if the recalled data runs outside the allowable range of the spreadsheet (A1:Z999). 9-21

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
  • 173
  • 174
  • 175
  • 176
  • 177
  • 178
  • 179
  • 180
  • 181
  • 182
  • 183
  • 184
  • 185
  • 186
  • 187
  • 188
  • 189
  • 190
  • 191
  • 192
  • 193
  • 194
  • 195
  • 196
  • 197
  • 198
  • 199
  • 200
  • 201
  • 202
  • 203
  • 204
  • 205
  • 206
  • 207
  • 208
  • 209
  • 210
  • 211
  • 212
  • 213
  • 214
  • 215
  • 216
  • 217
  • 218
  • 219
  • 220
  • 221
  • 222
  • 223
  • 224
  • 225
  • 226
  • 227
  • 228
  • 229
  • 230
  • 231
  • 232
  • 233
  • 234
  • 235
  • 236
  • 237
  • 238
  • 239
  • 240
  • 241
  • 242
  • 243
  • 244
  • 245
  • 246
  • 247
  • 248
  • 249
  • 250
  • 251
  • 252
  • 253
  • 254
  • 255
  • 256
  • 257
  • 258
  • 259
  • 260
  • 261
  • 262
  • 263
  • 264
  • 265
  • 266
  • 267
  • 268
  • 269
  • 270
  • 271
  • 272
  • 273
  • 274
  • 275
  • 276
  • 277
  • 278
  • 279
  • 280
  • 281
  • 282
  • 283
  • 284
  • 285
  • 286
  • 287
  • 288
  • 289
  • 290
  • 291
  • 292
  • 293
  • 294
  • 295
  • 296
  • 297
  • 298
  • 299
  • 300
  • 301
  • 302
  • 303
  • 304
  • 305
  • 306
  • 307
  • 308
  • 309
  • 310
  • 311
  • 312
  • 313
  • 314
  • 315
  • 316
  • 317
  • 318
  • 319
  • 320
  • 321
  • 322
  • 323
  • 324
  • 325
  • 326
  • 327
  • 328
  • 329
  • 330
  • 331
  • 332
  • 333
  • 334
  • 335
  • 336
  • 337
  • 338
  • 339
  • 340
  • 341
  • 342
  • 343
  • 344
  • 345
  • 346
  • 347
  • 348
  • 349
  • 350
  • 351
  • 352
  • 353
  • 354
  • 355
  • 356
  • 357
  • 358
  • 359
  • 360
  • 361
  • 362
  • 363
  • 364
  • 365
  • 366
  • 367
  • 368
  • 369
  • 370
  • 371
  • 372
  • 373
  • 374
  • 375
  • 376
  • 377
  • 378
  • 379
  • 380
  • 381
  • 382
  • 383
  • 384
  • 385
  • 386
  • 387
  • 388
  • 389
  • 390
  • 391
  • 392
  • 393
  • 394
  • 395
  • 396
  • 397
  • 398
  • 399
  • 400
  • 401
  • 402

9-21
4. Input the List number (1 to 26) of the list memory where you want to store the data and then
press
.
• Performing the next step will overwrite any data currently stored under the list memory
number you specified here with the data in the range of cells specified by “CellRange”.
5. Press
(EXE) or the
key to store the data.
Recalling Data from Memory to a Spreadsheet
The following table shows an overview of the recall operations for each type of memory. For
details about each operation, see the example operations following the table.
Memory Type
Recall Operation
List Memory
(List 1 ~ List 26)
You can recall data from a specified list memory to a range of
cells in a single row or a single column. While the first cell of
the range in a single row or single column is selected, press
(
)
(RCL)
(LIST), and then specify the list number on the
screen that appears.
Whether the data is recalled in a column direction or row direction
depends on the Setup screen’s “Move” setting (page 1-29).
File Memory
(File 1 ~ File 6)
You can recall data from a specified file memory to the spreadsheet.
Select the cell you want to be the upper left corner of the recalled
data and then press
(
)
(RCL)
(FILE). Next, specify the file
memory number on the screen that appears.
Matrix Memory
(Mat A ~ Mat Z)
You can recall data from a specified matrix memory to the
spreadsheet. Select the cell you want to be the upper left corner of
the recalled data and then press
(
)
(RCL)
(MAT). Next,
specify the matrix name on the screen that appears.
Example: To recall data from a matrix memory to a spreadsheet
1. On the spreadsheet, select the upper left cell of the range where you want the recalled data
to be input.
2. Press
(
)
(RCL)
(MAT).
• This will display a screen like the one shown to the right.
The “1st Cell” setting will show the name of the cell you
selected in step 1.
3. Input the name (A to Z) of the matrix memory whose data you want to recall and then press
.
4. Press
(EXE) or
to recall the data.
Important!
When recalling list memory, file memory, or matrix memory data, an error will occur if the
recalled data runs outside the allowable range of the spreadsheet (A1:Z999).