Monday, November 18, 2013

Excel: Copy formula to tens of thousands of rows

Check the Quickly Copy Excel Formula Down to achieve it.

Note that it only works if there is data in the adjacent column only. So if the data is on column A and formula to be copied is on column C, then it will NOT work. The formula to be copied has to be on column B.

No comments: