Search code examples
libreoffice-calc

Display the cells involved in the calculation of the current cell

Can I configure LibreOffice Calc so that when I select a cell with a calculation like:

=C1 * C2

then those cells are "shown" (border change or background color change)?

Solution

  • LibreOffice works that way without needing any configuring:

    highlight source cells

    To see this, click on =C1 * C2 to place the cursor in the formula bar, or double-click on cell C3.