Brand Control logo

Make it easy for users to stick to your brand — not to ignore it. 

Content Enablement Logo

Make it easy for users to find the right content instantly.

Content Creation logo

The solution for maximum efficiency in presentation creation.

Document Automation logo

The document editing and assembly process is streamlined.

People

Learn more about our clients and their success stories

Gears

Integrate empower® with your existing applications.

Blog

Get practical office tips, inspirational stories, and exclusive market assessments of the MS Office world

E-Books

Find MS Office related guides, e-books, whitepapers, videos, infografics and more 

Asset_Library

Everything you need to know about the MS Office world. Clearly summarized.

Office_Study

The Ultimate Global Office Suite Study - conducted by Nielsen

Office_Study

The Ultimate Office Suite Study for USA - conducted by Nielsen

Powerpoint_Study

Download our global PowerPoint Study conducted by Nielsen

Support

Our support is always there for you. You can also reach out to our Help Center. 

Best_Practice_Series

Our empower® Best Practice Series shows empower use cases in short 15min videos

Company

Learn about our values and why we get out of bed every morning

Microsoft_Partnership

Find out more about our very unique relationship with Microsoft

Press

An overview of the press releases about empower

Contact

Contact us at any time if you have any questions or feedback

Security

Your data is private and secure with empower®

Career

Find out now about the most important reasons for a career with us! Apply now!

Facilitate your work with Excel: track formulas

Stephan Kuhnert
November 24, 2022

According to our extensive Office study, 43% of users perceive the comprehension of complex formula relationships as the biggest time-consuming task. If a worksheet contains a large number of tables that are linked to each other via formulas, the probability of influencing other cells by editing or deleting cell contents is high.

Display a formula in Excel

A common way to find out which formula a cell content is based on is to select the corresponding cell by clicking on it and displaying the formula in the input line. Here the cell references are displayed, but it is not visible which other cell accesses the selected formula.

In order to clearly display both incoming and outgoing cell references, Excel offers the option of visualizing them using arrows:

  1. Select the "Formulas" tab in the menu bar. Under the item "Formula Auditing", you can now choose between two options for visualization.
  2. "Trace Precedents": this shows from which cells the selected cell receives its input.
  3. "Trace dependents": this shows which cells get their input from the selected cell.

New call-to-action

You May Also Like

These Stories on Excel

Subscribe by Email