Can you give us an example of your formula? (In most cases if you are doing
a calculation on a row by row basis you can enter the correct formula in the
1st cell and then copy it down as far as you need and it will automatically
increment the cell references in the formulas for you.)

"losthelp" wrote:

I have a spread sheet with some 15000 lines in it. One of the formulas in my
sheet has been chaged from top to bottom. It is caculating for the incorrect
rows. I need the formula to be changed back so the formula reflects the line
# it is on. How can i change this without having to do each line manually?