Whats the quickiest way to copy a formula down 13,000 lines in exc

[IMF]

any help would be appreciated

 

[gcanty]

Use Ctrl-C or "Copy" to capture the formula you want to copy,
Use Ctrl-G to go down 13,000 rows,
Use your mouse to click on the last cell in which you wish to copy your
formula,
Hold the Shift Key while you
press and release the End Key and
press and release the Up Arrow Key
Use Ctrl-V or "Paste" to copy the formula in the all of the cells

There may be faster ways but this works for me. Good Luck!

 

[KePaHa]

If there is continuous data in the column to the left of your formula, you
may be able to hover over the AutoFill handle of the first formula cell and
double-click to copy it -- Excel will copy it until it finds a blank cell in
the column to the left.

 

[Gord Dibben]

Select formula in A1

In Name box type A1:A13000 and ENTER

CTRL + d to fill down.


Gord Dibben MS Excel MVP