Multiply an Entire Column by a Number in Excel (without using a formula)
443.2 هزار بار بازدید -
5 سال پیش
-
Want to multiply an entire
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/trumpexc...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
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/trumpexc...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
5 سال پیش
در تاریخ 1398/07/10 منتشر شده
است.
443,246
بـار بازدید شده