February 9, 2012 by datapig Leave a reply »
Most of us know that Excel allows you to evaluate a formula by tracing back to the formula’s precedents. That is to say, Excel will draw a line back to each cell that plays a part in the formula.
If you’ve never tried it, here’s the deal.
Click on the cell that contains your formula, then click the Trace Precedents command found on the Formula tab.
Excel will draw helpful lines back to each precedent cell.
Sometimes the lines lead to cells that are way off to the side of your spreadsheet (off the screen).
Instead of squinting your eyes while following the line as you scroll your way to the precedent cell, just jump there. Simply double-click on any of the lines to jump to the source cell.
If the precedent cell is off the current spreadsheet, Excel will give you an icon with a dotted line. Again, double-click on the dotted line (NOT the icon). This will call up the Go To dialog box where you can select which precedent cell you want to jump to.
If the precedent cell is in a completely different workbook, one of two things will happen when you double-click on the line:
If the other workbook is open, Excel will call up the Go To dialog box, where you can jump to the precedent cell in the other workbook.
If the other workbook is closed, you will an error stating that your reference is not vali
http://datapigtechnologies.com/blog/index.php/double-clicking-your-way-to-formula-precedents/
ليست هناك تعليقات:
إرسال تعليق