After using C-c =
to enter a formula, I want that formula to apply to every row in that column. How can I achieve this?
My personal preference is to add a column formula directly into the cell, instead of having to remember so many keyboard shortcuts.
Just start typing into the cell, starting with a =
sign. For example, in column 3 type =$1+$2
and that formula will apply to all of the column directly.
You need to C-c C-c
to actually apply the formula and calculate results.
For a single cell (non-column) formula, start with :=
instead.