How can I apply a formula to an entire column without dragging?

[rogernelson2244]

Hey guys,
I have a very long column with several hundred rows. I need to paste a formula into the top row, then apply it to all the rows below. Can I do it without having to drag the box all the way?
Cheers and thanks,
Roger

 

[rogernelson2244]

Brilliant, Rick.
Many thanks. I'm learning something new every day.
Cheers,
Roger

 

[rogernelson2244]

Brilliant, Rick.
Many thanks,
Roger

 

[rogernelson2244]

Brilliant, Rick.
I'm learning something new every day.
Many thanks,
Roger