Shortcut to insert a formula on many rows

  • Thread starter Vitalie Ciobanu
  • Start date
V

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!
 
V

Vitalie Ciobanu

I knew a shortcut but this works the same way.

Thank you David!!

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


David McRitchie said:
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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Vitalie Ciobanu said:
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... :(
Click to expand...
Click to expand...
 
V

Vitalie Ciobanu

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

Regards,
Vitalie
 
Top