I can't for the life of me remember how to denote a fixed
cell in a formula. For example, I want each cell in a
column to be divided by a single cell, A15. If I just
enter A15 into the formula and copy the formula down the
column, each cell will be divided by A15, A16, A17
progressively on down the line. How do I fix A15 as a
constant in the formula??!!

Thanks to anyone who can refresh my memory.

Karen,

Use $A$15 rather than A15.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Karen" wrote in message
...
I can't for the life of me remember how to denote a fixed
cell in a formula. For example, I want each cell in a
column to be divided by a single cell, A15. If I just
enter A15 into the formula and copy the formula down the
column, each cell will be divided by A15, A16, A17
progressively on down the line. How do I fix A15 as a
constant in the formula??!!

Thanks to anyone who can refresh my memory.

Chip,
The dollar signs!! Thank you so much.
-Karen

-----Original Message-----
Karen,

Use $A$15 rather than A15.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Karen" wrote in
message
...
I can't for the life of me remember how to denote a
fixed
cell in a formula. For example, I want each cell in a
column to be divided by a single cell, A15. If I just
enter A15 into the formula and copy the formula down the
column, each cell will be divided by A15, A16, A17
progressively on down the line. How do I fix A15 as a
constant in the formula??!!

Thanks to anyone who can refresh my memory.


.