## You are learning Cell Referencing in MS Excel

How to copy formulas with relative references and maintain accuracy?

Here's how to copy formulas with relative references and maintain accuracy in Excel:

Method 1: Simple Copy and Paste (Default Behavior)

1. Enter your formula: Create the formula in the desired cell. For example, suppose you have the formula `=A1+B1` in cell C2.

2. Select and copy: Click on cell C2 (containing the formula). Then, press `Ctrl` + `C` (Windows) or `Command` + `C` (Mac) to copy the cell.

3. Paste to new location(s): Click on the cell(s) where you want the copied formula to appear. For instance, you might select cells D2, E2, and F2.

4. Paste: Press `Ctrl` + `V` (Windows) or `Command` + `V` (Mac) to paste the formula.

Result: Excel will automatically adjust the cell references in the formula based on their relative positions to the original cell. In this case, the formulas will become `=B2+C2` in cell D2, `=C2+D2` in cell E2, and so on. This is because Excel assumes you want the calculations to reference the corresponding cells relative to where you pasted the formula.

Method 2: Using Fill Handle (For Sequential Copying)

1. Enter your formula: Create the formula in the desired cell as in method 1.

2. Click and drag the fill handle: Hover your mouse over the small black square in the bottom right corner of the cell containing the formula. When the cursor changes to a plus sign (+), click and drag the fill handle down (or across) to the cells where you want the formula copied.

3. Release the fill handle: Excel will automatically adjust the cell references based on the direction you dragged. Dragging down will increment row numbers, while dragging right will increment column letters.

This method is useful for copying formulas to a sequential range of cells.

Important Note:

- If you want to keep the original cell references absolute (referencing specific cells regardless of where the formula is copied), you can use the `F4` key. After entering the cell reference in your formula, press `F4` to toggle between relative and absolute references (indicated by a dollar sign $ before the row and/or column).

By following these methods, you can ensure your formulas update correctly when copied to different locations in your Excel spreadsheet.