Copy to bottom of sheet quickly
 

Is there a way to copy a formula to the bottom of a worksheet without copying
down by selecting the black cross???


Thanks


Mark

Copy to bottom of sheet quickly
 

If the formula is in the first row (say in column A) then select column A
(click on A in column header), Edit/Fill-down

If the formula is in (say) the 2nd row then Edit/Jump(Ctrl-G), enter in
Reference field A2:A65536, click OK, then Edit/Fill-down

Regards,
Stefi

€žsantaviga€� ezt Ã*rta:

Is there a way to copy a formula to the bottom of a worksheet without copying
down by selecting the black cross???


Thanks


Mark

Copy to bottom of sheet quickly
 

I cant see the edit/jump on the edit menu?

M

"Stefi" wrote:

If the formula is in the first row (say in column A) then select column A
(click on A in column header), Edit/Fill-down

If the formula is in (say) the 2nd row then Edit/Jump(Ctrl-G), enter in
Reference field A2:A65536, click OK, then Edit/Fill-down

Regards,
Stefi

€žsantaviga€� ezt Ã*rta:

Is there a way to copy a formula to the bottom of a worksheet without copying
down by selecting the black cross???


Thanks


Mark

Copy to bottom of sheet quickly
 

Hi, Done it, sorry for being a clown.

Regards.


Mark

"Stefi" wrote:

If the formula is in the first row (say in column A) then select column A
(click on A in column header), Edit/Fill-down

If the formula is in (say) the 2nd row then Edit/Jump(Ctrl-G), enter in
Reference field A2:A65536, click OK, then Edit/Fill-down

Regards,
Stefi

€žsantaviga€� ezt Ã*rta:

Is there a way to copy a formula to the bottom of a worksheet without copying
down by selecting the black cross???


Thanks


Mark

Copy to bottom of sheet quickly
 

You are welcome! Thanks for the feedback!
Stefi


€žsantaviga€� ezt Ã*rta:

Hi, Done it, sorry for being a clown.

Regards.


Mark

"Stefi" wrote:

If the formula is in the first row (say in column A) then select column A
(click on A in column header), Edit/Fill-down

If the formula is in (say) the 2nd row then Edit/Jump(Ctrl-G), enter in
Reference field A2:A65536, click OK, then Edit/Fill-down

Regards,
Stefi

€žsantaviga€� ezt Ã*rta:

Is there a way to copy a formula to the bottom of a worksheet without copying
down by selecting the black cross???


Thanks


Mark