20050401
k
k
k
k
k
Filling a Range of Cells with the Same Content
You can use the following procedure to fill a range of cells with the same formula,
expression, value, or text.
u
To fill a range of cells with the same content
○ ○ ○ ○ ○
Example
To use the “FILL” command to fill cells A2 through B3 with the formula
= A1+1
The A1 cell name of the formula is a relative reference. This means the
formula is = A1+1 in cell A2, = A2+1 in cell A3, etc.
In this example, it is assumed that 1 is already input into cell A1, and 2 is
input into cell B1.
1. Select the range of cells from A2 through B3.
• See “To select a range of cells” (page 9-3-4) for more information.
2. Press
2
(EDIT)
6
(
g
)
1
(FILL).
• This displays the Fill dialog box.
This is the range of cells you selected in step 1.
3. While the “Formula” line is highlighted, enter the content you want to be filled into each
of the cells in the selected range.
• Here we will enter “=A1+1”.
9-4-13
Inputting and Editing Cell Data
Summary of Contents for fx-9860G AU PLUS
Page 1: ...fx 9860G AU User s Guide E http edu casio com ...
Page 2: ...Important Please keep your manual and all information handy for future reference ...
Page 27: ...20050401 1 1 Keys 1 1 1 Keys ...
Page 335: ...20050401 u u u u u Input Example u u u u u Results 6 5 25 Tests ...
Page 361: ...20050401 Calculation Result Output Example p F distribution probability 6 7 15 Distribution ...
Page 435: ...20050401 8 8 2 Program Library egcw w ww w ...
Page 437: ...20050401 8 8 4 Program Library Example 1 Example 2 fw baw bf w fw baw ca w ...
Page 439: ...20050401 8 8 6 Program Library wba wb w w d ...
Page 441: ...20050401 8 8 8 Program Library dw fcde wfcde wfcde fcde w daw w 20070101 ...
Page 443: ...20050401 8 8 10 Program Library b awaw bwaw aw x d w ...
Page 590: ...CASIO COMPUTER CO LTD 6 2 Hon machi 1 chome Shibuya ku Tokyo 151 8543 Japan SA0701 E ...