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

 

[Sinbad]

Enter the formula as you need it, copy the cell then select the column and paste.

I tried it with the formula in d1,then copied it, selected column d and pasted. It filled all the way down to the end.

Alternately, type the formula, copy the cell, select the cells that need the formula and paste

In this case again, formula in d1. copy and selected d2:d20 and paste, all now had the formula

 

[rogernelson2244]

Slight modification to that question. I will insert the formula into row 4, and wish to apply it to the following 250 rows. This means I cannot just select the entire column.

I'd love to not have to drag. Is there a way to do that?
Cheers,
Roger

 

[rogernelson2244]

Thanks, Sinbad. Wow, I had Aladin help with a previous issue, and now I have Sinbad on board.

I forgot that I need to apply the formula from row 4 on down. Can I do that without dragging the box?
Cheers,
Roger

 

[Tatts]

You can double click on the bottom right hand corner of the cell with the formula.
This will fill down all the cells until there is a break (a blank cell) in the column to the left.

I.E. if there is data in column A down to A250 and you double click the right of cell B4 it will fill down to B250.

 

[rogernelson2244]

In other words, can I select the entire column, then deselect just the top 3 rows?
Thanks.

 

[rogernelson2244]

Thanks, Tatts, I'll give it a go!!!!!!!

 

[Rick Rothstein]

Assuming your column is Column C, put the formula into C4 and press Enter. Now select the cell and press CTRL+C to copy it, then type C4:C253 in the Name Box (the field to the left of the Formula Bar) and press Enter which will select all the cells, then press CTRL+V to paste the formula throughout the selection.

 

[jolivanes]

You've got all kind of answers already but if you want to try a macro, maybe this.

For Column C

Sub MaybeThis()
    Cells(4, 3).AutoFill Destination:=Range(Cells(4, 3), Cells(250,3)), Type:=xlFillDefault
End Sub

If the 250 is just a number you picked out of thin air and you would want to copy the formula
relative to the length of another Column, a slight modification is required.

 

[rogernelson2244]

Hi jolivanes and thanks,
I think macros are a bit beyond my current capabiltites with Excel, but I very much appreciate taking the time to let me know.
Thanks.
Roger

P.S. Are there really people who make no mistakes?