Need fast help in excel counting

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Maybe copy n paste special > multiply ?
Copy A2. Select the range A1:D1, right-click > paste special > check
multiply > ok
 
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.
 
Back
Top