## You are learning Cell Referencing in MS Excel

What happens when you copy formulas with mixed references?

When you copy formulas with mixed references in Excel, the cell references adjust based on the new location in the worksheet. Here's how it works:

* Mixed References: A mixed reference combines absolute and relative references. For instance, $A1*B2 has an absolute column reference (A) for the first cell and a relative column reference (B) for the second cell.

* Copying the Formula: When you copy a formula with mixed references, the relative references will change according to their new position.

Here's an example:

Imagine you have a formula =A1*B2 in cell C2. This formula multiplies the value in cell A1 by the value in cell B2.

* Copying to C3: If you copy this formula down to cell C3, the formula will automatically adjust to =A2*B3. This is because the relative row reference (1) in the original formula increments by 1 to reflect the new row (3) in the copied cell. The absolute column reference (A) remains unchanged.

Benefits of Mixed References:

* Maintain Consistency: Using mixed references ensures the row or column you want to stay fixed remains absolute, while other references adjust appropriately when copied.

* Efficiency: Mixed references save you time by allowing you to create a single formula and copy it across multiple cells without manually adjusting each cell reference.

Remember:

* Absolute references (e.g., $A$1) will not change when copied.

* Relative references (e.g., B2) will adjust based on the new position.

By understanding how mixed references behave when copied, you can create efficient and adaptable formulas in your Excel spreadsheets.