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

Dragging a formula in a column 1
How do I increment the row and column of a cell in a formula? 2
drag formula down from columns that go acros 3
Circular reference, Indirect, and Sum 3
Finding the cell loacation that matches a specific value in a rang 3
using a cell's reference to return a value. 3
Help with changing column reference in formula 4
Copying formulas across columns 2

Top