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 ?

CodePudding user response：

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