I want to repeat a cell in a formula for multiple cells
P Peo Sjoblom Feb 17, 2005 #2 If you are copying a formula and wants to keep one cell reference use absolut reference $A$1