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?
 
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

Similar Threads

Cumulative formula for word table 0
Copy addition formula of non-consecutive horizontal cells 2
Excel - Wich Function should I use? 1
drag formula down from columns that go acros 3
Converting a number into a cell reference 2
Dragging a formula in a column 1
get a cell reference as a result of an If Function 1
Dragging a formula down isn't working - where am I going wrong? 1

Top