Browse » Home
Tuesday, March 15, 2011
How to Go to Precedent Worksheets in Excel
Enable the Display Options
1. Open the saved Excel worksheet.
2. Click the 'File' tab on the command ribbon. A list of commands will appear.
3. Click 'Options.' The 'Excel Options' dialog box will open.
4. Click the 'Advanced' button on the left pane. The 'Advanced' pane will appear.
5. Scroll down the right pane to the 'Display' section.
6. Select the named workbook in the 'Display Options for This Workbook' text box.
7. Select the radio button for 'All' in the 'For Objects, Show' option.
8. Open another workbook if it contains the formula's reference cells. An open workbook makes the cells accessible for the 'Trace Precedents' option.
9. Click 'OK.' The 'Excel Options' dialog box will close.
Apply the Trace Precedents Command
10. Click and drag on the cell that contains the formula. The selected cell will appear highlighted. The formula will appear in the Formula Bar.
11. Click the 'Formulas' tab.
12. Click the 'Trace Precedents' button in the 'Formula Auditing' group. Tracer arrows will appear superimposed on the cells. Blue arrows indicate no errors. Red arrows indicate cells that cause errors. A black arrow points to a worksheet icon if the selected data cell is referenced by another worksheet's cell.