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

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

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

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.

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

Hi abcdbaker,

Would something like this work? =$A$1


--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=487836

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

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" wrote in message
...
How do I lock a cell reference in the formula that I'm dragging to other
rows.