how can i apply a formulla to an entire column

[sonu]

how can i apply a formulla to an entire column - double the value in the same row different column

 

[Frank Kabel]

Hi
if your data is in column A enter in B1
=2*A1
and copy this formula down as far as needed

 

[David McRitchie]

Some elaboration on teh "copy this formula down as needed"

If the data in column A is entirely contiguous, you can double-click
on the fill-handle. The little bulge lower right corner of a cell,

If the data is not contiguous you can grab and drag the fill handle down as
needed.

If you know a definite range B1:B200 you can put that into the name box
to the left of the formula bar, and use Ctrl+D to copy down.

More information on fill-handle (including missing) can be found at
http://www.mvps.org/dmcritchie/excel/fillhand.htm