I have a column "K", with different prices in the cells. I want to adjust pricing, by multiplying each cell by .965
Is there a formula to change the whole column, or do I HAVE to enter the formula for each cell?
2006-10-02 10:32:51 · 5 answers · asked by Jan L 2 in Computers & Internet ➔ Software
You don't have to re-enter the formula for each cell. Just type .965 in a blank cell in your spreadsheet and hit Ctrl-C to copy the contents. Highlight the entire column of figures you need to adjust and go to Edit, Paste Special, Multiply. That will automatically multiply all the values in the column by that number. After you finish doing this, you can delete the single cell that you entered the value into.
2006-10-02 10:44:14 · answer #1 · answered by LB 4 · 2⤊ 0⤋
You should be able to enter it for one cell and then copy and paste it in to all the others in one go by highlighting the rest of the column and pasting the formula
2006-10-02 17:41:30 · answer #2 · answered by evergreenIvi 2 · 0⤊ 0⤋
you can insert a column next to the one with the prices (that would be column L), then fill in the formule: L1 = 0.965*K1 and than copy down this formula in column L. you will than have the adlusted price in column L
2006-10-02 17:43:18 · answer #3 · answered by Guy VS 4 · 0⤊ 0⤋
L1=K1 *.965
drag down by clicking on L1 and getting solid cross in lower right corner of cell- excel should recongnize formula and apply it to all cells- click on cells to see if it worked
2006-10-02 17:44:46 · answer #4 · answered by Anonymous · 0⤊ 0⤋
insert a column next to it an type =K#*.965 then just hide column k
the # = row number
2006-10-02 17:44:18 · answer #5 · answered by Kikka 3 · 0⤊ 0⤋