Forum home » Delegate support and help forum » Microsoft Excel Training and help » Auditing

Auditing

ResolvedVersion 2003

Thu 30 Oct 2008, 16:12 Delegate Matthew said...

Matthew has attended:
Excel Intermediate course

Auditing

How do you audit cells which are link to cells in separate worksheets or workbooks?

Fri 7 Nov 2008, 09:11 Trainer Simon said...

RE: Auditing

Hi Matthew,

Thank you for your question.

If you click on the cell and then choose Show Precedents, you will see an audit arrow appear pointing to a little spreadsheet icon. When you double click on the line, the Go To box appears and you can view the cell references.

I hope this answers your question.

Regards

Simon

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Create Equations in Excel 2010

Here's how to create basic mathematical
equations in your Excel 2010 worksheet.

1) On the Ribbon, click the Insert tab
2) In the Symbols group, click the arrow next to Equation
3) Select from the equations and the equation will be inserted in a text box

Or you can create your own equation:

1) Insert and select the text box
2) On the Ribbon, click the Insert tab
3) In the Symbols group, click Equation
4) The Equation Tools Design Ribbon will now be displayed

View all Excel hints and tips

Auditing

Auditing

RE: Auditing

Excel articles

Excel tip:

Create Equations in Excel 2010