Tips, Tricks, and Answers

The following articles are available. Click the article's title (shown in bold) to see the associated article.

Accessing Dependant and Precedent Information The auditing tools in Excel allow you to easily see what cells are precedents to or dependent upon the current cell. In large, complex worksheets, you may find it helpful to extract this information and place it in a new worksheet where you can work with it more easily. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Counting Precedents and Dependents Do you need to know how many precedents or dependents there are on a worksheet? You could count them manually, or you could let a short macro derive the information for you. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Tracing Dependent Cells When auditing a worksheet, you can use a tool that will show cells that are dependant on whatever is in the current cell. This allows you to quickly and visually see how the current cell affects other cells in the worksheet. This tip explains the Trace Dependents tool, which provides this information. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Tracing Precedent Cells When auditing a worksheet, you can use a tool that will show cells on which the current cell depends.. This allows you to quickly and visually see which cells affect the current cell. This tip explains the Trace Precedents tool, which provides this information. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Understanding Auditing Excel provides a set of auditing tools that allow you to analyze a worksheet to make sure that the results you are getting are what you expect. This tip examines how auditing works in Excel, explaining the basics. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

 

RSS Feeds

 Daily Nuggets (an ExcelTip every day)

 Allen Wyatt's ExcelTips (the weekly classic)