Text Documents (Writer)
General Information and User Interface Usage
Command and Menu Reference
Navigating Text Documents
Formatting Text Documents
Templates and Styles
Graphics in Text Documents
Tables in Text Documents
Objects in Text Documents
Sections and Frames in Text Documents
Tables of Contents and Indexes
Fields in Text Documents
Calculating in Text Documents
Special Text Elements
Automatic Functions
Numbering and Lists
Spell Checking, Thesaurus and Languages
Troubleshooting Tips
Loading, Saving, Importing, Exporting and Redacting
Master Documents
Links and References
Printing
Searching and Replacing
HTML Documents (Writer Web)
Spreadsheets (Calc)
General Information and User Interface Usage
Command and Menu Reference
Functions Types and Operators
Loading, Saving, Importing, Exporting and Redacting
Formatting
Filtering and Sorting
Printing
Pivot Table
Pivot Chart
Scenarios
Subtotals
References
Viewing, Selecting, Copying
Formulae and Calculations
Presentations (Impress)
General Information and User Interface Usage
Command and Menu Reference
Loading, Saving, Importing, Exporting and Redacting
Formatting
Effects
Objects, Graphics and Bitmaps
Text in Presentations
Drawings (Draw)
General Information and User Interface Usage
Command and Menu Reference
Loading, Saving, Importing and Exporting
Formatting
Objects, Graphics and Bitmaps
Groups and Layers
Text in Drawings
Viewing
Database Functionality (Base)
Formulae (Math)
General Information and User Interface Usage
Charts and Diagrams
General Information
Macros and Scripting
Office BASIC
General Information and User Interface Usage
Command Reference
Guides
Python Scripts Help
General Information and User Interface Usage
Programming with Python
Script Development Tools
Office Installation
Common Help Topics
General Information
Office and Microsoft Office
Office Options
Wizards
Letter Wizard
Fax Wizard
Agenda Wizard
HTML Export Wizard
Document Converter Wizard
Configuring Office
Working with the User Interface
Digital Signatures
Printing, Faxing, Sending
Drag & Drop
Copy and Paste
Charts and Diagrams
Load, Save, Import, Export, PDF
Links and References
Document Version Tracking
Labels and Business Cards
Inserting External Data
Automatic Functions
Searching and Replacing
Guides
Trace Precedents
This function shows the relationship between the current cell containing a formula and the cells used in the formula.
Traces are displayed in the sheet with marking arrows. At the same time, the range of all the cells contained in the formula of the current cell is highlighted with a blue frame.
To access this command...
Choose Tools - Detective - Trace Precedents.
Shift+F9
This function is based on the principle of layers. For example, if the precedent cell to a formula is already indicated with a tracer arrow, when you repeat this command, the tracer arrows are drawn to the precedent cells of this cell.