Excel Subtraction Magic: Subtract 3 from a Column - Episode 2099
46.1 هزار بار بازدید -
7 سال پیش
-
Microsoft Excel Tutorial: How to
Microsoft Excel Tutorial: How to subtract a value from a column in Excel
Method 1: Temporary column with =D6-3, Copy and Paste values
Method 2: Put the 3 in any cell. Copy it. Paste Special, Subtract
Welcome to the MrExcel Podcast, where we bring you tips and tricks to help you master Excel. In this episode, we'll be discussing how to subtract a value from a column in Excel. This question came up on Quora and while there was already an answer, I wanted to share my own method with you.
First, let's take a look at the existing answer on Quora. The suggested method was to create a temporary column and use the formula =D6-3, then copy and paste the values. While this method works, it can be time-consuming and there is no audit trail to track any mistakes.
Instead, I suggest using the Paste Special function. Simply copy the value you want to subtract, in this case 3, and then select the column you want to deduct from. Right-click and choose Paste Special, then select Subtract. This will automatically subtract the value from each cell in the selected column. Just make sure to choose Values if the cells have different formats.
Now, I must warn you, this method can be risky as there is no audit trail. So make sure to double check your values before deleting the temporary column. But let's face it, even the original method had no audit trail. So it's important to always be careful when working with formulas and functions in Excel.
If you want to learn more about Excel and become a power user, check out my book "Power Excel with MrExcel". You can find the link in the top right-hand corner of this video. It's packed with even more tips and tricks to help you excel in Excel.
Thank you for tuning in to this episode of the MrExcel Podcast. I hope you found this tip helpful and will join us for our next netcast. Don't forget to like, comment, and subscribe for more Excel content. See you next time!
Buy Bill Jelen's latest Excel book: www.mrexcel.com/products/latest/
You can help my channel by clicking Like or commenting below: www.mrexcel.com/like-mrexcel-on-youtube/
#excel
#microsoft
#microsoftexcel
#exceltutorial
#exceltricks
#excelhacks
#evergreen
This video answers these common search terms:
how to add subtract and subtract in an excel cell
how to use paste special subtract in excel
how to paste special in excel subtract
how to special paste in excel
how to do special paste in excel
how do you paste special in excel
what are the options of the special paste in excel
can you subtract in excel
excel how to subtract numbers
how can i subtract in excel
how do subtract in excel
how to get excel to subtract numbers
how to add subtract and multiply in an excel cell
how to use paste special multiply in excel
how to paste special in excel multiply
Table of Contents:
(00:00) Subtracting a value from a column
(00:12) Existing answer on Quora using Helper Column
(00:34) Discussion on the risks of the method
(01:00) Faster Method with Paste Special Subtract
(01:35) Reminder to be careful with the method
(01:59) Clicking Like really helps the algorithm
Join the MrExcel Message Board discussion about this video at www.mrexcel.com/board/threads/1153925/
7 سال پیش
در تاریخ 1396/03/19 منتشر شده
است.
46,119
بـار بازدید شده