hellow can it be possbile to multiply whole of an excel table by some constants.
V vijaya reddy Dec 4, 2007 #1 hellow can it be possbile to multiply whole of an excel table by some constants.
S Stephen Dec 4, 2007 #2 vijaya reddy said: hellow can it be possbile to multiply whole of an excel table by some constants. Click to expand... Put the constant into a spare cell somewhere. Copy this cell. Select the table. Use Edit > Paste Special > Multiply > OK
vijaya reddy said: hellow can it be possbile to multiply whole of an excel table by some constants. Click to expand... Put the constant into a spare cell somewhere. Copy this cell. Select the table. Use Edit > Paste Special > Multiply > OK
A Allllen Dec 4, 2007 #3 yes A B C D E F 1 3 9 7 2 6 2 1 3 4 8 3 4 5 7 In cell D1 you can do =A1*$A$5 and then autofill across and down this multiplies everything in table A1:C3 by 7
yes A B C D E F 1 3 9 7 2 6 2 1 3 4 8 3 4 5 7 In cell D1 you can do =A1*$A$5 and then autofill across and down this multiplies everything in table A1:C3 by 7
