Brother International PDP350CJ Owner's Manual - English - Page 171
To copy a formula to adjacent cells, Copying to adjacent cells
View all Brother International PDP350CJ manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 171 highlights
In either case, the result depends on what kind of information you are copying or moving. When you copy or move values and labels from one location to another, they appear the same in both locations. When you copy or move formulas, however, Spreadsheet automatically adjusts relative references for the new position of the formula. You can override this automatic adjustment by using absolute references. For more information about relative and absolute references, see Using References in Formulas" on page 151. Copying to adjacent cells The Fill Right and Fill Down choices provide a handy shortcut when you want to copy the contents of the active cell across a row or down a column. This is particularly useful when you copy formulas. In a budget spreadsheet, for example, you can enter a formula to calculate the total for the January column, and then copy the formula to the columns for February through December, as shown in the following illustration. You enter the formula in this cell. Then, you copy the formula to these cells. When you copy the formula, Spreadsheet automatically adjusts the relative references so that the total is correct for each month. "To copy a formula to adjacent cells: 1. Select a range of cells starting with the cell containing the formula you want to copy and ending with the last cell to which you want to copy the formula, as shown in the following example: Result of Formula You can copy the formula from cell B11 to the range to the right. Spreadsheet 157