How to make a cell address remain constant when copying a formula

  • Thread starter Thread starter Guest
  • Start date Start date
Deana


The $ sign is used to change cell references from "relative" to absolute". This
fixes the reference so's it will not change as copied down or across.

$A1 is absolute column and relative row.

$A$1 is absolute column and row.

A$1 is relative row and absolute column.

See help on relative and absolute cell references for more on this.


Gord Dibben MS Excel MVP

Gord Dibben MS Excel MVP
 
Deana


The $ sign is used to change cell references from "relative" to absolute". This
fixes the reference so's it will not change as copied down or across.

$A1 is absolute column and relative row.

$A$1 is absolute column and row.

A$1 is relative row and absolute column.

See help on relative and absolute cell references for more on this.


Gord Dibben MS Excel MVP

Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for Next Sheet and Every Other Cell 12
Is there a way to set a cell value to be constant in formulas? 4
Formula constants? 2
Excel: Format Control: 'cell link' reamins constant. How to copy 0
Mapping integers to strings 5
Counting repeating cell values 2
How do I set a constant multiplier in an equation? 3
Number of payments remaining 4

Back
Top