excel 2003 visual basic intermediate course - errors formulae split frames

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel 2003 visual basic intermediate course - Errors, formulae, split frames

excel 2003 visual basic intermediate course - Errors, formulae, split frames

resolvedResolved · Low Priority · Version Standard

Gill has attended:
Excel Intermediate course
Access Intermediate course

Errors, formulae, split frames

how do you trace errors

RE: errors, formulae, split frames

Hi Gill

Thank you for your question.

The Trace Precedents feature can be used to help ascertain where an error in a formula may have arisen from.

To use this, bring up the Formula Auditing toolbar on your screen. Then select the cell containing the formula producing the error; and click the Trace Precedents button on the Formula Auditing toolbar. A series of arrows will appear on the spreadsheet, indicating which cells are supplying data to the cell with the erroneous formula. If you click the Trace Precdents button again, this should show you which cells are supplying data to the cells indicated by the first set of arrows.

Once you have been able to determine what is causing the error, you can remove the arrows from your screen by clicking the Remove All Arrows button on the Formula Auditing toolbar.

Amanda


 

Excel tip:

Moving or Copying Sheets Between Workbooks in Excel 2010

Here's how to move or copy sheets between workbooks in Excel 2010:

Open the sheet you want to move or copy then on the Ribbon click the Home tab. Click Format. Under Organize Sheets, select the option Move or Copy Sheet and then choose where you want the sheet to be moved/copied to.

View all Excel hints and tips


Server loaded in 0.09 secs.