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

G

Gord Dibben

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
 

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

What does $ stand for in an excel formula 1
What is the deifference between writng A3 or $A$3 in a function? 1
Excel 97 error copying cell containing 'IF' function and labels 2
Retaining cell reference in destination, when sorting source file 3
Conditional Formatting Question 1
Using icon sets with relative references 0
Help with converting a block of cells with Absolute and mixed references to relative references 3
changing from relative to absolute cell reference in multiple form 1

Top