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

S

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

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
 
Top