How to Multiply in Excel Using Paste Special

In this video, you'll learn how to multiply in Excel using Paste Special Operators. These come in handy when you want to avoid applying formulas or using helper columns.
This technique can also be used if you want to multiply every Nth Value (such as every third cell).
Read More About it: trumpexcel.com...
Free Excel Course - trumpexcel.com...
Paid Online Training - trumpexcel.com...
Best Excel Books: trumpexcel.com...
⚙️ Gear I Recommend:
Camera - amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - amzn.to/2uzhVHd
Wireless Mic: amzn.to/3blQ8uk
Lighting - amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: www.youtube.co...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial

[@georgeh738]

That's very clear thank you - I was having to edit macros to get this function. I really should sit down and look at all the new bits 2016 is offering.

[@daborean]

Thanks for the tip. I have to perform this operation all the time

[@himelu]

You are freaking awesome!!!! Thank you!!!

[@RajaSekhargvd]

Hi Bansal, thanks for this detailed video; is it possible to show the cell reference instead of 1.1 (in above example) by using the same operation (paste special multiply)

[@luismoreyra6804]

Excelent video!! Thank you!!

[@SHAHJAHA-KHILJI]

yor are good teacher, thanks you sir

[@Danny-Do-It]

Hi great video!how can you setup an excel document - to protect your cells in a way that formatting (conditional and font size etc) are protected? I want to allow users to paste but for the formatting of the cells to remain the same and unchanged. I dont want to have to Paste Special > I dont trust users will remember to paste this way so i need to restrict it please anyone help