In this article, we will learn how to create and copy formulas in Google Sheets using relative references. We will create a formula that will add items to different columns. As an alternative to creating a formula for each row, we can create one formula in one cell and then copy the formula to the other rows. We will use relative references so that the formula calculates the total correctly for each item.
Step 1: Create a new or open an existing Google sheet spreadsheet
Step 2: Enter or import the data that you would like to perform calculations on.
Step 3: Select the cell that will contain the formula. In this case, we have selected C2. To do so, just click on the cell.
Step 4: Now, enter your formula, starting with an equal "=" sign. In this case, we will use the formula, = A2+B2
Step 5: Now, on your keyboard, press enter, and the results of the calculation will be displayed in the cell.
Step 6: Now click on the "C2" cell. A fill handle will appear in the bottom right corner of the cell. Click and drag the fill handle over the cells you would like to fill. In this case, we will copy from C3 to C10.
Now, release the mouse, and the formula will be copied to all selected cells, with the relative references displaying the results in every cell.
In this article, we have learned how the formulas can be copied and displayed across the Google sheet cells using relative reference. You can double-check the filled cells to ensure that they are pasted If you are unsure, the formulas are accurate. The relative cells need to differ from every cell depending on its rows
Related Google Sheet Question and Answers
Article Contributed By :