Need fast help in excel counting

[Guest]

I have a row with numbers A1-1, B1-2, C1-3, D1-4 and in A2-3.
Is it possible to multiply all numbers in row with A2 number automatically
or some formula?

Thank you!

Peter

 

[MartinW]

Hi Peter,

Your post isn't very clear.
In your example.

You can copy A2
Select A1 to D1
Right click on the selection
Pick Paste Special
Check multiply
And OK out.

That does what you seem to be saying but I suspect
you are trying something beyond that.


HTH
Martin

 

[Guest]

Maybe copy n paste special > multiply ?
Copy A2. Select the range A11, right-click > paste special > check
multiply > ok

 

[David Biddulph]

By formula:
=A1*$A2 and copy across the 4 columns.

Alternatively, if you want to change the existing values in row 1, select
A2, copy, select A1 to D1, Edit/ Paste Special/ Multiply.

 

[Guest]

Thank you David Biddulph!
It was exacly what i needed.

Kind regards,

Peter