HOW DO I SET UP A PRECEDENCE DIAGRAM?

  • Thread starter Thread starter Guest
  • Start date Start date
Hi,

I'm not sure what you mean by a precedence diagram, however, if what you
want to see are the Precedence arrows (which can be printed):
1. Select a cell with a formula
2. Choose the command Tools, Formula Auditing, Trace Precedences

This will cause a blue arrow to appear.

It's easier to work with this feature if you float the Formula Auditing
toolbar - Tools, Formula Auditing, Show Auditing Toolbar.

You can click the Trace Precedence button more than once to show multiple
levels.

Unfortunately this command works on one cell at a time - this does not mean
that you can only tract precedences for one cell, but that you need to select
each cell one at a time, you can't apply it to a range with a single command.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top