LibreOffice Calc - Automatically expand references

October 2016

To enable this option under LibreOffice Calc:
  • Launch LibreOffice select the Calc application.
  • Click on Tools > Options.
  • Go to LibreOffice Calc > General.
  • In the "Input settings", check "Expand references when new columns /rows are inserted".
  • Click on OK to validate.

Related :

This document entitled « LibreOffice Calc - Automatically expand references  » from CCM ( is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.