Search code examples
org-mode

How do you copy a formula down a column with the org-mode spreadsheet


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?


Solution

  • 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.