Locking a cell reference in a formula


O

odonnjk

I have a worksheet that has formulas built within 6 columns. I want to drag
the formula in each column down 100 rows, but as I am calculating a date that
references only 1 cell (A1) when I drag the formula, it picks up A2, A3, A4
etc. as the formula progresses down the column. Is there a way to lock the
cell reference to A1 so that when I drag the formula down the column, that
cell reference doesn't change?
 
Ad

Advertisements

I

Iriemon

Add a $ sign in front of the cell reference.

Example

$A1 Locks the column but allows the rows to change
A$1 locks the row but allows the column to change
$A$1 locks both the row and the column (locks it to a specific cell.) This
is what you are asking.
 

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

Top