98.1 % recommend us More live stats... RSS feeds What's this? All hints and tips:

Hints and tips home » Excel hints and tips » Trace Dependents / Precedents without the blue arrows

Trace Dependents / Precedents without the blue arrows

Rather than using the toolbar you can press CTRL+] which is the equivelent of trace dependants and CTRL+[ for precendants. Both of these ways though will not show the blue arrows but jump to the cell containing the formula.

Added by Martin on 5th October 2006

More Excel hints and tips, like:

• Shortcuts for working with named ranges in Excel
• Viewing two Excel 2010 Workbooks at the same time
• Sorting data stored in rows