Quick navigation

Sounds like via formula auditing. Try the toolbar. Cheers, Fazza

Thanks but sorry could you specify a little more on how to do this?

Thank you.

Sure. See Excel help for "formula auditing".

There is a toolbar for "formula auditing", though it has a different names in different versions of Excel. If you haven't got the toolbar showing you can bring it up by right clicking from an existing toolbar, including the menu bar, and then selecting the "formula auditing", or different name in earlier version, toolbar. Or, you can go via menu path view, toolbars, then formula auditing.

Select precedents and if the inputs are from off the worksheet double click in the details that come up in the GoTo box.

regards, Fazza

If you do not allow "edit directly in cell" (in Tools|Options|Edit) then you get some of this functionality simply by double-clicking the cell with the formula.

I don't actually know the "rules" about this, but my experience goes something like this:

a) If the formula just links to cells on the current sheet, the precedent cells should all get selected.

b) If the formula links only to cells on another sheet, then I think the double-click takes you to the first of those "other sheet" cells used in the formula.

c) If the formula contains links to cells on the current and other sheet(s) then I think the double-click will perform
either a) or b) depending on what type of link the first one in the formula is.

Is this behaviour documented formally somewhere?