Mixed Reference in Microsoft Excel

What is a Mixed Reference?

A Mixed Reference is a cell reference in which either the row or the column is fixed, while the other part remains changeable when a formula is copied.

Mixed Reference mein $ symbol ka use karke hum sirf row ya sirf column ko fix karte hain.

There are two types of Mixed References:

1. Column Fixed: $A1

2. Row Fixed: A$1

1. Column Fixed Reference — $A1

In $A1:

• $A → Column A is fixed

• 1 → Row can change

Example

=$A1*B1

If the formula is copied downward:

=$A1*B1
=$A2*B2
=$A3*B3

Notice:

$A1 → $A2 → $A3

The column A remains fixed, while the row number changes.

Remember

$A1 = Column Fixed + Row Changeable

2. Row Fixed Reference — A$1

In A$1:

• A → Column can change

• $1 → Row 1 is fixed

Example

=A$1*B2

If the formula is copied across columns, the row remains fixed:

=A$1*B2
=B$1*C2
=C$1*D2

Notice:

A$1 → B$1 → C$1

The row 1 remains fixed, while the column changes.

Remember

A$1 = Row Fixed + Column Changeable

Mixed Reference Formula Chart

              Mixed Reference
                    │
          ┌─────────┴─────────┐
          ↓                   ↓
       $A1                  A$1
          ↓                   ↓
   Column Fixed           Row Fixed
   Row Changes            Column Changes

Relative, Absolute and Mixed Reference

Easy Comparison

A1      → Nothing Fixed
$A$1    → Everything Fixed
$A1     → Column Fixed
A$1     → Row Fixed

Why is Mixed Reference Used?

Mixed Reference is useful when we want one part of a cell reference to remain fixed while the other part changes as the formula is copied.

For example, in a calculation table, we may want to keep a particular row or column constant while allowing the other reference to adjust automatically.

$ Symbol ka Simple Rule

$A1
 ↑
Column Fixed

A$1
  ↑
Row Fixed

$A$1
 ↑  ↑
Both Fixed

So, the position of the $ symbol tells us what is fixed.

Quick Revision

$A1 → Column Fixed
A$1 → Row Fixed
$A$1 → Row + Column Fixed
A1 → Nothing Fixed

The provided reference specifically explains Mixed References, the use of the $ symbol, and how row/column references behave when formulas are copied.

One-Line Definition

A Mixed Reference is a cell reference in which either the row or the column is fixed, while the other part can change when th