I want to copy a formula down several rows and lock a cell ref.

[abcdbaker]

How do I lock a cell reference in the formula that I'm dragging to other rows.

[keithl816]

Hi abcdbaker,

Would something like this work? =$A$1

[Rowan Drummond]

Use $ signs eg = $A$1. See help on absolute versus relative references.

Hope this helps
Rowan

abcdbaker wrote:
> How do I lock a cell reference in the formula that I'm dragging to other rows.

[Max]

Put a dollar sign ($) in front of the col &/or row reference
e.g.:

$A$1: locks the point to both col & row ref of the cell A1
$A1: locks the point only to the col ref: "A" of the cell A1
A$1: locks the point only to the row ref: "1" of the cell A1

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"abcdbaker" <abcdbaker@discussions.microsoft.com> wrote in message
news:AA8329C9-D633-4821-879F-E005D840ECF2@microsoft.com...
> How do I lock a cell reference in the formula that I'm dragging to other
rows.