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

Video Description

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 Free Excel Course - https://trumpexcel.com/learn-excel/ Paid Online Training - https://trumpexcel.com/excel-training/ Best Excel Books: https://trumpexcel.com/best-excel-books/ ⚙️ Gear I Recommend: Camera - https://amzn.to/3bmHko7 Screen Recorder - techsmith.z6rjha.net/26D9Q USB Mic - https://amzn.to/2uzhVHd Wireless Mic: https://amzn.to/3blQ8uk Lighting - https://amzn.to/2uxOxRv Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1 Note: Some of these links here are affiliate links! #Excel #ExcelTips #ExcelTutorial