Visualizing and Tracing Formulas

Tracing formulas through the Formula Auditing tools in Excel can be invaluable in navigating complex formulas and diagnosing unexpected results. This guide reviews methods of visualizing and tracing formulas, including Trace Precedents, Trace Dependents, and Evaluate Formula.

Click to download the Tracing Formulas Guide (FREE)
Click to download the Tracing Formulas Guide (Donation)

Tracing Formulas 150 x 150

Multiple Windows & Arranging Views in Excel

Using appropriate “view” tools in Excel can help you better navigate worksheets and files. This guide shows how to freeze rows and columns, split a worksheet into panes that scroll separately, and how to show multiple windows side by side.

Click to download the Arranging Views Guide (FREE)
Click to download the Arranging Views Guide (Donation)

Arranging Views 150 x 150