LibreOffice Calc - Automatically expand references

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.
Published by jad05. Latest update on April 2, 2012 at 10:22 AM by jad05.
This document, titled "LibreOffice Calc - Automatically expand references ," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (
LibreOffice Calc - Use Enter key to switch to edit mode
LibreOffice Calc - Hide Grid lines