Excel 2007 : Column multiplication

**djv0001** · 02-02-2009, 05:12 PM

I would like to multiply an entire column by one cell. How do i do this? The formula i have for the first cell in the column is C8=B8*F4 i want to copy this formula into cells B9-B24 with excel automatically changing the F4.

**Shijesh Kumar** · 02-02-2009, 05:19 PM

Enter the no. with which you want to multiply the entire column in any cell.

copy the cell.

Select the column to which u want to multiply the number...

Right click... select paste special .... select the radio button... Multiply (its under second section ... operations)

**djv0001** · 02-02-2009, 05:46 PM

thanks for the info. But i would like to be able to edit the cell that i am using as a multiplier and have the entire column automatically update when i change the value in the cell. the way you explained in the formula for the cells in the column become C#=B#*17. instead of 17 i would like it to read C#=B#*G4

**DonkeyOte** · 02-02-2009, 06:18 PM

Your cell references are not consistent in your post so it's impossible to offer a suggested formula, however, it sounds as though you may want to have a read through XL Help regarding Absolute referencing.

**TheLostBoy** · 02-02-2009, 06:50 PM

So, you want C8 to display the product of B8*F4, then want C9 to display the product of B9*F4, and so on, ending with B24*F4 being displayed in C24?

If this is the case, enter in C8

Please Login or Register  to view this content.

then hit enter & grab the lower right corner of C8 & drag down through C24. That gives the result of the B cell in the same row multiplied by the value in F4.