G Guest Aug 2, 2004 #1 how can i apply a formulla to an entire column - double the value in the same row different column
F Frank Kabel Aug 2, 2004 #2 Hi if your data is in column A enter in B1 =2*A1 and copy this formula down as far as needed
D David McRitchie Aug 2, 2004 #3 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
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
