I have a small square orgmode spreadsheet with some data in it and 2 extra columns to the right with some formulas, like average and sum. I want to add some new columns in the middle of my spreadsheet in order to input more data.

Question: Is there a way to update all formulas automatically in order to include the new columns?

Example: =vsum($2..$12) and I'm adding two new columns, so I want the formula to be updated to =vsum($2..$14); since there are many formulas, I want them all to be updated automatically

  • Which spreadsheet?
    – Stefan
    Sep 28, 2015 at 2:31
  • orgmode, sorry about that Sep 28, 2015 at 2:41

1 Answer 1


Basically every table manipulating function is updating formulas. For example : M-S-right includes a new column (before the cursor) updating formulas to the new number of columns.

C-u C-c * is recalculating all your formulas in the spreadsheet.

Also a C-c C-c on a #+tblfm: line is (re)applying all the formulas in the table.

For more advanced stuff, like automatically recalculating please have a look at the org manual.

  • 1
    To expand: Almost every column/row manipulating command for org-table updates the function definitions. Sep 28, 2015 at 11:23
  • @Jonathan Leech-Pepin: Right, I was too focused on operations for columns, , will update my answer ! Sep 28, 2015 at 13:14
  • Thanks! I didn't know there were such commands. This solves my problem! Thanks!!! :D Sep 28, 2015 at 13:32
  • @GuilhermeSalomé: You're welcome! And yes org-mode is ingenious... :-) Sep 28, 2015 at 15:50
  • @Dieter.Wilhelm Should the formula update the moment I have inserted the column? I'm using the insert column shortcut and my formulas are not updated and I"m not asked to confirm formula updates. Checked the source for the insert column function and it has code for fixing formulas, but it doesn't work. May 30, 2019 at 18:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.