'How to subtract multiple cells
I have the above cells and i want to substract each individual row . i.e. 137.61-137.61, 132.88-270.49 and print each one of the results on the respective row cell next to them . I know i can do =(A1-B1) to each individual row but is there a shorter way to do that for all the cells ?
Solution 1:[1]
After subtracting for the first operation, when you hold the cursor from the right and drag it to the last cell, it will automatically subtract all of them.
If you want watch this video: https://www.youtube.com/watch?v=1ElcsZpA3h4&ab_channel=ExcelTutorialsbyEasyClickAcademy
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | proghan |