is it possible to multiply whole of excel table by some constant

V

vijaya reddy

hellow

can it be possbile to multiply whole of an excel table by some constants.
 
S

Stephen

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Best (Easiest) to Multiply Columns by a Constant? 7
mutliply a worksheet by a constant 2
multiply range of cells by a fluctuating exchange rate 8
Paste Special Formula Multiply feature doesn't work anymore 2
Need Help Creating a Macro to Multiply Cells by a Constant Number 5
Multiply a co;omn by a constant 2
HOW DO I MULTIPLY MANY CELLS BY A CONSTANT CELL ? 12
Multiply by a constant 3

Top