Is it possible to put a formula that applies to a whole column? Example, I want A1-B1=C1, A2-B2=C2, and so on. Do I have to manually add the formula per row, or is there a shortcut I can put in the C column so that its automatically column A minus column B?
MacBook, macOS 10.14
enter the formula in cell cell C1
select cell C1, copy
select column C, paste
enter the formula in cell cell C1
select cell C1, copy
select column C, paste
Recommend having a look at Help > Numbers Help in your menu. You will find a lot of useful information there that is searchable.
For example you will find this explanation of how to fill or "autofill" data in cells.
SG
Numbers- subtract columns formula
