Brother International WP230B Owners Manual - English - Page 216
Copying, Other, Cells
View all Brother International WP230B manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 216 highlights
Example 1: 1. Enter 3 in Al, 1 in A2, 2 in A3, then enter the formulas 2*A2+$A1 in B2 and 2*A3+$A1 in B3. The addresses A2 and A3 are relative while the address $A1 is absolute. Relative addresses are updated when copied. Absolute addresses are never updated. 2 2. Now copy the range 82..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 203.) NOTE: Use the RECALC function to update the results. 3 1 5 RE::: M tk., 2 7 17 PITCH:10 Copying One Cell to Many Other Cells CODE C CODE L L IND 1. Place the cursor on the cell that you want to copy. 2. Press CODE + C (see Help Menus on page 184). This message appears: Mark range to be copied. Press RETURN when done. 3. Press RETURN without moving the cursor. This message appears: 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). 204 Spreadsheet