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

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

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