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 - [ Ссылка ]
Paid Online Training - [ Ссылка ]
Best Excel Books: [ Ссылка ]
⚙️ Gear I Recommend:
Camera - [ Ссылка ]
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - [ Ссылка ]
Wireless Mic: [ Ссылка ]
Lighting - [ Ссылка ]
Subscribe to get awesome Excel Tips every week: [ Ссылка ]
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
