Copy Formula Down Automatically - 3M Rows!

I have 3-Million rows of data (across 3 CSV files).

In column A, I have the number of years the company has been in business (ie: 2, 9, etc). I want to change that into the year.

I tried by putting =2013-A1 in cell B1 and Shift+Enter but nothing happened. All I can get is B1 to complete.

I know this can be done but I'm missing something...

The last time I had to do this I put a rubber-band around my mouse and set it manually fill - that took about an hour.

Thanks!

Originally Posted by Craig K.

In the bottom right of the active cell, there is a little box on the border. When your mouse is over it, the cursor turns into a solid black plus sign. Double click the box in the bottom right. That is the auto fill handle.

how do I do this without having to manually drag the formula? I already know how to do that.

I have 3 Million rows and doing it manually will take a very long time. and be painful.

Originally Posted by Craig K.

You don't drag it, you double-click it and it fills down for all adjacent cells.

Wow! That was as easy as breathing. Thank you so much - it worked.

+Rep given


...Onward!