# Using Auditing

Below is a description of how to use the cell dependencies for the job auditing feature.

## Displaying the Dependencies of a Specific Cell

1. Select the cell that contains the data that you want to find dependent and precedent cells.
2. On View menu, click Auditing and select Increase Dependency Levels. Alternatively, from the Auditing Toolbars, press the Increase Dependency Levels button.
3. To identify the next level of cells that provide data to the active cell, select Increase Dependency Levels again.
4. To remove dependency arrows one level at a time, on the view menu, click Job Auditing and select Decrease Dependency Levels. Alternatively, from the toolbar, press the Decrease Dependency Levels button.

## Displaying the Dependencies in Error for a Specific Cell

1. Select the cell that contains the data in error that you want to find dependent and precedent cells.
2. On the view menu, click Auditing and select Increase Dependency Levels. Alternatively, from the toolbar , press the Increase Dependency Levels button.
3. On the view menu, click Auditing and select Show Errors Only. Alternatively, from the toolbar, press the Show Dependency Errors Only button. This will remove the green and blue arrows that indicate normal dependent and precedent cell relationships, leaving only the yellow and red arrows that indicate a dependent or precedent cell in error.

## Displaying Only the Cell Dependency Errors That Exist in the Spreadsheet

1. Highlight the entire spreadsheet by clicking the upper-left corner of the spreadsheet.
2. On the view menu, click Job Auditing and select Increase Dependency Levels. Alternatively, from the toolbar, press the Show Dependency Levels Increase button. This will activate all of the dependency arrows that exist within the job.
3. On the view menu, click Job Auditing and select Show Dependency Errors Only. Alternatively, from the toolbar, press the Show Dependency Errors Only button. This will remove the green and blue arrows that indicate normal dependent and precedent cell relationships, leaving only the yellow and red arrows that indicate a dependent or precedent cell in error.

## Jumping to the First Error (#ERR) Precedent of the Active Cell

1. Select a cell that depends upon another cell in an error condition.
2. On the view menu, click Job Auditing and select Go To First Error. Alternatively, from the toolbar, press the Go To First Error button.
3. This will cause the spreadsheet to jump to the active cell's first precedent cell that is in error, and will make that cell the active cell. Nothing will happen if the active cell does not have any precedent cell in error, or if the active cell is in the main spreadsheet.

## Removing All of the Dependency Arrows

1. To remove the dependency arrows from the spreadsheet, on the view menu, click Auditing and select Reset Dependency Levels. Alternatively, from the toolbar, press theRest Dependency Levels.