Thus, every cell into which the formula is pasted will contain a formula that has a cell reference one cell to the left of the target cell. In the original formula, Excel knows that the cell being referenced was one cell to the left of the cell containing the formula. As Excel pastes each cell, it modifies the formula so the cell reference is the same, relative to the new location, as it was to the old. Now suppose you copy cell B1 and paste it into B2 through B5. This simply means that B1 will contain the same value as in A1. For example, suppose that the cell at B1 contains the simplest of formulas, as follows: When you copy a formula that contains a cell reference, Excel automatically assumes that you want the cell reference modified to reflect the cell into which you are pasting the formula. Thus, the cell at the intersection of column D and row 15 is known as cell D15. In Excel, cells are referred to by a combination of their column letter and row number. In our example, we want to reference cell E14 on the Menu Order worksheet.You already know that one of the powerful features of spreadsheets is that you can refer to the contents of other cells within a formula.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |