Copy Formula

[Guest]

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.

 

[Guest]

Thank you that worked!

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.