ExcelBanter - HOW DO I SET UP A PRECEDENCE DIAGRAM?

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.

--
Cheers,
Shane Devenshire

"G Heard" wrote:

I do not know how to do a precedence diagram. Please help