How to copy Excel formulas that all refer to the same data cell. .

[schmitte]

I want to copy a formula to many cells. However, I want all cells to use the
data from only one cell and not change to sequential cells. How do I do this?

 

[Jason Morin]

Make the cell reference absolute, meaning place $ around
the reference.

Before: F4
After: $F$4

A quick way to do this is click inside the reference and
press F4.

HTH
Jason
Atlanta, GA

 

[Frank Kabel]

Hi
see:
http://www.cpearson.com/excel/relative.htm

--
Regards
Frank Kabel
Frankfurt, Germany

I want to copy a formula to many cells. However, I want all cells to use the
data from only one cell and not change to sequential cells. How do I

do this?