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

any help would be appreciated

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

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!

"IMF" wrote:

any help would be appreciated

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

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.

"IMF" wrote:

any help would be appreciated

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

Select formula in A1

In Name box type A1:A13000 and ENTER

CTRL + d to fill down.


Gord Dibben MS Excel MVP

On Wed, 18 Jun 2008 11:18:04 -0700, IMF wrote:

any help would be appreciated