Copy Formula: duplicate the formula in each of the cells

[JLD]

If I have a formula in a cell such as M1 and want to copy it to the last row
to duplicate the formula in each of the cells in the M collumn, how can I do
that quickly without just dragging it down the collumn. This takes alot of
time if I have 30,000 + rows and alot of formulas.

Thanks

JLD

[Teodomiro]

If I have a formula in a cell such as M1 and want to copy it to the last row
to duplicate the formula in each of the cells in the M collumn, how can I do
that quickly without just dragging it down the collumn. This takes alot of
time if I have 30,000 + rows and alot of formulas.

Thanks

JLD

Highlight M1, ctrl-c. Arrow down to M2. While holding down "shift", press End and Arrow Down. This should highlight the entire column. Hit Enter to paste.

[JLD]

Thank you that worked!

"Teodomiro" wrote:

>
> JLD Wrote:
> > If I have a formula in a cell such as M1 and want to copy it to the last
> > row
> > to duplicate the formula in each of the cells in the M collumn, how can
> > I do
> > that quickly without just dragging it down the collumn. This takes alot
> > of
> > time if I have 30,000 + rows and alot of formulas.
> >
> > Thanks
> >
> > JLD
>
> Highlight M1, ctrl-c. Arrow down to M2. While holding down "shift",
> press End and Arrow Down. This should highlight the entire column.
> Hit Enter to paste.
>
>
> --
> Teodomiro
>
>
> ------------------------------------------------------------------------
> Teodomiro's Profile: http://www.excelforum.com/member.php...o&userid=33140
> View this thread: http://www.excelforum.com/showthread...hreadid=531064
>
>