Copy to bottom of sheet quickly

's Computer Specifications

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

Thanks

Mark

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
moving to the bottom of my document quickly	PeterL	Microsoft Word Document Management	2	3rd Dec 2008 09:49 PM
How to quickly remove ALL formatting on a sheet	Dave	Microsoft Excel Discussion	4	4th Feb 2008 04:49 PM
Macro to go quickly to a sheet	Darin Kramer	Microsoft Excel Programming	4	8th Oct 2005 03:00 PM
How can I quickly move to the bottom (end) of a long Word documen.	=?Utf-8?B?c3Rhbmo2NzY5?=	Microsoft Word Document Management	2	7th Mar 2005 04:25 PM
Macro - copy entire row and paste at bottom of another sheet	miker1999	Microsoft Excel Programming	4	31st Jan 2004 05:28 PM