Highlight Precedent Cells in LibreOffice Calc
Auditing formulas in LibreOffice Calc is essential for verifying data accuracy and troubleshooting calculation errors. Using Calc’s built-in “Detective” tool, you can visually trace and highlight all precedent cells—the cells directly or indirectly referenced by a specific formula. This guide explains how to enable precedent arrows, audit multiple levels of data dependencies, and remove trace markers from your spreadsheet.
Steps to Trace Precedents for a Single Formula
- Select the Target Cell: Click on the cell containing the formula you want to audit.
- Open the Detective Menu: Go to the top menu and select Tools > Detective.
- Trace Precedents: Click on Trace Precedents from the submenu, or press the keyboard shortcut Shift + F7.
Calc will draw blue arrows pointing from the source (precedent) cells directly into the selected formula cell. If the formula references a range of cells, a blue box will outline the range with an arrow leading to the formula.
Tracing Multiple Levels of Precedents
If your formula relies on cells that also contain formulas, you can trace deeper dependencies:
- Press Shift + F7 (or select Tools > Detective > Trace Precedents) a second time.
- Calc will expand the visual trace by drawing additional arrows from the second-level precedent cells to the first-level precedents.
- Continue repeating the command to trace through all historical levels until all source data is mapped.
Tracing Precedents Across the Entire Worksheet
To audit multiple formulas or review dependencies across an entire sheet at once:
- Highlight the entire range of formula cells you want to check (or press Ctrl + A to select the entire sheet).
- Go to Tools > Detective > Trace Precedents (or press Shift + F7).
- Visual arrows will appear simultaneously for all selected formula cells.
How to Remove Precedent Arrows
Once your audit is complete, you can clear the dependency arrows from your view:
- Remove One Level: Go to Tools > Detective > Remove Precedents.
- Remove All Arrows: Go to Tools > Detective > Remove All Traces.