Note, Copying one cell to many other cells, Notes – Brother WP330MDS User Manual
Page 212
Attention! The text in this document has been recognized automatically. To view the original document, you can use the "Original mode".
B3
2*A3+$A1
PITCH: 10
A B
C
D
E
t
3
2
1
5
3
2
7
2. Now copy the range B2..B3 to C2. Note that the formulas of C2 and C3 are
2*B2+$A1 and 2*B3+$A1. Because $A1 is an absolute address, it was not
changed when copied. (See “Absolute and Relative Addresses” on page 201.)
NOTE:
Use the RECALC function to update the results.
i2^B2iSAl
PITCH: 10
V.:-'
.V.
iiO- ■
V- ■.
¿■ ■ ■ y-ii'er,.:.--
3
2
1
5 ■ ;
a
2
7
17
4
Copying one Cell to Many Other Cells
1. Position the cursor on the cell that you want to copy.
2. Press CODE + C (see “Help Menus” on page 182). This message will appear;
Mark range to be copied. Press RETURN when done.
3. Press RETURN without moving the cursor. This message will appear:
Move block cursor to destination and press RETURN.
4. Move the cursor to the upper-left corner of the destination range and press
CODE+ L (not RETURN).
5. Move the cursor to the lower-right corner of the range and press RETURN. The
cell is copied to the destination range,
NOTES:
• Relative addresses are automatically updated. (See “Copying a Range of Cells”
on page 201 and “Absolute and Relative Addresses” on page 201.)
• This variation of the copy function is very useful for automatic input of formulas.
202