Multiply an Entire Column by a Number in Excel (without using a formula)

Want to multiply an entire column or range by a number? In this video, I will show you a really fast method of doing this.

While you can always use another column and have the formula to do this. The method I cover in this video is a lot faster.

All you need to do is have the number that you want to multiply in a cell (any cell). Now copy this cell and paste as special in the range/column with which you want to multiply it. In the Paste Special dialog box, there is an option to multiply and give the result in the same column.

Once done, you can delete the cell that has the value with which you multiplied.

The resulting data is static so you don't need to worry about converting a formula to value after multiplying a number with the column.

This video is a part of my 'Excel is two-minute' series, where I share simple and quick tips to help you speed up your work and be more efficient

⚙️ Gear I Recommend:

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

[anaregina]

Extremely useful! Can't believe I spent so many years without this knowledge! Thanks!!!

[DJMandwich]

Thank you! For so long, I had been making a new column with the multiplication formula, then copy-pasting the values back over the old column, and then deleting the new column. This is so much faster.

[algore]

this is exactly what I was looking for thank you so much

[neetupandey]

I've been trying to do this for the past 15 mins....and it just takes 15 seconds. Thank you so much. I needed to calculate grades for my students. Thanks a lot.

[kaitstubba]

Thank you for taking time to explain this and the two different methods, extremely helpful! :-)

[rapconnoisseur]

Thank you for keeping it so short and simple!

[tylerjackson]

Perfect video right to the point. Saved me a lot of hassle. Thanks.

[tundeolaosebikan]

wow! you are the best... i've been looking for this since. God bless you

[swaminathbera]

Thank you, this method is so useful in multiplying the values in same column.

[blacksheep]

Yes! Thats what I was looking for and official helpdesk cant even help me. Thank you m8

[jackbain]

I was trying to figure this out for an hour, thanks so much!

[AgricUltra]

Perfect! Simple and well explained. Thank you.

[MominMukhlis]

BESTEST SUMIT SIR... I was just looking for the exact same thing.... superb

[alexeyr]

What a neat little trick! Thanks for the video, good sir. You are awesome!

[gnusnoon]

Thank you much - have been looking at this for a while with Microsoft help and this is much better!

[vajradandi]

Excellent. Really useful and very shortcut. Thanks for teaching us. 👌👌👌🙏🙏

[DevdattaTV]

Thank you for this video. Short and to the point.

[marciebryant]

Thanks!! It was easy, and exactly what I needed.

[skyriserentals]

Brief and well explained. Thank you !

[Ann-koyn]

FANTASIC!!! I needed to multiply 390 values by 2 without a formula or adding a column for new total but I had no clue how to do it for 390 different values. THANK YOU!