Hello and welcome to this Excel tips video.
I am Sumit Bansal and in this video I'm going
to show you how to multiply an entire column
with a number in Excel.
Here I have the sales data and what I want
to do is calculate the sale target for next
year, which is going to be 10% higher than
the current sales value. One way of doing
it is to have another column and multiply
this existing value with the factor (the number).
In this case it would be this value multiplied
by 1.1, which would give me a value which
is 10% higher, and then I can copy this formula
for this entire range. Now this is one way
of doing it. But in this video I'm going to
show you another method.
In this case what you need to do is have the
value with which you want to multiply in one
of the cells. Select that cell and copy it
(Control + C). Now come to this entire range,
select this range, right-click on click on
Paste special.
In the Paste Special dialog box, in "Operations,"
you have this option "Multiply." And now when
I click on "Multuply" and click okay, it will
instantly give me the final result in the
same column itself.
So I do not have to add a new column. All
I need to do is just multiply this right away
and it is going to give me the values here
itself. Now I can come here and I can delete
this. This is a static result so this is not
dependent on any existing value and it'll
instantly give you the result.
This is, again, another quick way of multiplying
a column with a value in Excel. That's it
in this video. I hope you found this useful.
Also, if you like the videos, please subscribe
to this YouTube channel so that you're notified
whenever I come up with a new video. Thank
you and have a nice day.
