Shortcut to insert a formula on many rows

[Vitalie Ciobanu]

Hi,

I forgot how to make something and hope somebody form here can help me.
For example I have 5000 rows of some random numbers in column A. In column B
I want to insert a formula (any formula). How can I "insert" that formula
for all 5000 rows with data at once. I know there is a shortcut for this but
I forgot...

Thanks for help!

 

[David McRitchie]

Hi Vitalie,
Double click on the fill handle.
http://www.mvps.org/dmcritchie/excel/fillhand.htm
it will copy the formula down as long as there is something
in the column to the left.

 

[Vitalie Ciobanu]

I knew a shortcut but this works the same way.

Thank you David!!

--
Vitalie Ciobanu
AISBERG
http://aisberg.rau.ro

 

[David McRitchie]

Hi Vitalie,
oops, and the shortcut key is Ctrl+D
it's not quite the same as the fill-handle,
and is described on same page as use of fill-handle
http://www.mvps.org/dmcritchie/excel/fillhand.htm
and list of shortcut keys is on
http://www.mvps.org/dmcritchie/excel/shortx2k.htm

 

[Vitalie Ciobanu]

Yep, I saw it.
Thanks anyway, for now I'm doing my job with the "double click"

Regards,
Vitalie