Filling in equation for several rows

[grey_fox33]

I have a worksheet with over 8,000 lines of data. Each line represents days. At the end of each row is an amount. What I am doing is comparing the amount for one day against the amount the previous day so I enter a formula at the end of each row to compare the two amounts.

Once I setup the formula for row one, I click on the formula and drag it all the way down, and Excel automatically fills in the formula for me.

The problem is that I prefer not to have to drag it all the way down 8,000 rows. Since there are so many rows it takes a while for me to get all the way down there. Is there some way to do this without the click and drag?

[shg]

If there is data immediately adjacent left or right, just double-click the fill handle.