Copying a formula down 20K rows
 

I have a rather large spread sheet and would like to copy formulas from one
row to the next. It seems like there should be an easier way of copying to
20K rows than grabbing the fill handle and moving down that long.
I tried reviewing some of the tips in "programing" but I have no idea how or
where to type those directions (macros???I hope not).
Thanks

Copying a formula down 20K rows
 

If there are entries immediately to the left (or the right) of the column
where the formulas are to do, then all you need do is double click the fill
handle
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"lizhere" wrote in message
...
I have a rather large spread sheet and would like to copy formulas from one
row to the next. It seems like there should be an easier way of copying
to
20K rows than grabbing the fill handle and moving down that long.
I tried reviewing some of the tips in "programing" but I have no idea how
or
where to type those directions (macros???I hope not).
Thanks

Copying a formula down 20K rows
 

One way:

With your formula already entered in A1,
Right click in A1 and choose "Copy",
Click in A2,
Click in the Name Box (left of formula bar)
Type in
a20000
Hold down <Shift
Hit <Enter
Release <Shift
Hit <Enter again,
You're done!
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===



"lizhere" wrote in message
...
I have a rather large spread sheet and would like to copy formulas from one
row to the next. It seems like there should be an easier way of copying to
20K rows than grabbing the fill handle and moving down that long.
I tried reviewing some of the tips in "programing" but I have no idea how or
where to type those directions (macros???I hope not).
Thanks

Copying a formula down 20K rows
 

If no adjacent columns of data use this method.

In the namebox type A1:A20000 and ENTER

Then CTRL + D to copy down.


Gord Dibben MS Excel MVP

On Mon, 18 Feb 2008 08:43:05 -0800, lizhere
wrote:

I have a rather large spread sheet and would like to copy formulas from one
row to the next. It seems like there should be an easier way of copying to
20K rows than grabbing the fill handle and moving down that long.
I tried reviewing some of the tips in "programing" but I have no idea how or
where to type those directions (macros???I hope not).
Thanks

Copying a formula down 20K rows
 

I couldn't get the double click to work, but this one did! Thanks so much



"RagDyeR" wrote:

One way:

With your formula already entered in A1,
Right click in A1 and choose "Copy",
Click in A2,
Click in the Name Box (left of formula bar)
Type in
a20000
Hold down <Shift
Hit <Enter
Release <Shift
Hit <Enter again,
You're done!
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===



"lizhere" wrote in message
...
I have a rather large spread sheet and would like to copy formulas from one
row to the next. It seems like there should be an easier way of copying to
20K rows than grabbing the fill handle and moving down that long.
I tried reviewing some of the tips in "programing" but I have no idea how or
where to type those directions (macros???I hope not).
Thanks

Copying a formula down 20K rows
 

use this method if the formula is in A1 correct?



"Gord Dibben" wrote:

If no adjacent columns of data use this method.

In the namebox type A1:A20000 and ENTER

Then CTRL + D to copy down.


Gord Dibben MS Excel MVP

On Mon, 18 Feb 2008 08:43:05 -0800, lizhere
wrote:

I have a rather large spread sheet and would like to copy formulas from one
row to the next. It seems like there should be an easier way of copying to
20K rows than grabbing the fill handle and moving down that long.
I tried reviewing some of the tips in "programing" but I have no idea how or
where to type those directions (macros???I hope not).
Thanks

Copying a formula down 20K rows
 

Yes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"lizhere" wrote in message
...
use this method if the formula is in A1 correct?



"Gord Dibben" wrote:

If no adjacent columns of data use this method.

In the namebox type A1:A20000 and ENTER

Then CTRL + D to copy down.


Gord Dibben MS Excel MVP

On Mon, 18 Feb 2008 08:43:05 -0800, lizhere

wrote:

I have a rather large spread sheet and would like to copy formulas from
one
row to the next. It seems like there should be an easier way of copying
to
20K rows than grabbing the fill handle and moving down that long.
I tried reviewing some of the tips in "programing" but I have no idea
how or
where to type those directions (macros???I hope not).
Thanks

Copying a formula down 20K rows
 

Thank you!

"Bernard Liengme" wrote:

Yes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"lizhere" wrote in message
...
use this method if the formula is in A1 correct?



"Gord Dibben" wrote:

If no adjacent columns of data use this method.

In the namebox type A1:A20000 and ENTER

Then CTRL + D to copy down.


Gord Dibben MS Excel MVP

On Mon, 18 Feb 2008 08:43:05 -0800, lizhere

wrote:

I have a rather large spread sheet and would like to copy formulas from
one
row to the next. It seems like there should be an easier way of copying
to
20K rows than grabbing the fill handle and moving down that long.
I tried reviewing some of the tips in "programing" but I have no idea
how or
where to type those directions (macros???I hope not).
Thanks

Copying a formula down 20K rows
 

Double-click won't work unless there is contiguous data in an adjacent column.


Gord

On Mon, 18 Feb 2008 09:14:02 -0800, lizhere
wrote:

I couldn't get the double click to work, but this one did! Thanks so much



"RagDyeR" wrote:

One way:

With your formula already entered in A1,
Right click in A1 and choose "Copy",
Click in A2,
Click in the Name Box (left of formula bar)
Type in
a20000
Hold down <Shift
Hit <Enter
Release <Shift
Hit <Enter again,
You're done!
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===



"lizhere" wrote in message
...
I have a rather large spread sheet and would like to copy formulas from one
row to the next. It seems like there should be an easier way of copying to
20K rows than grabbing the fill handle and moving down that long.
I tried reviewing some of the tips in "programing" but I have no idea how or
where to type those directions (macros???I hope not).
Thanks