+ Reply to Thread
Results 1 to 3 of 3

Tracing a formula (NOT precedent/dependent tracking, formula audit)

  1. #1
    Registered User
    Join Date
    06-09-2016
    Location
    nyc
    MS-Off Ver
    2013
    Posts
    2

    Tracing a formula (NOT precedent/dependent tracking, formula audit)

    Hey guys - thanks in advance for the help.

    In a prior job I used a shortcut to "jump" through a formula, but I cant remember what it's called or the shortcut. The shortcut would pull up a box, then I could use the arrow keys to "jump" or trace the formula, cell by cell (input by input). For example, if the formula was =A1+B52+C100, I could pull up this box, then easily jump from cell A1, to cell B52, to cell C100, by using the arrow keys. This allowed for easy formula auditing, especially if the formula contained references to other worksheets.

    For the life of me I cant remember what it is, and it was very useful. My searches on the internet are not helpful, everything that shows up is tracing precedent/dependents w/ arrows, forumla audit, and error checking, which is not what I'm looking for.

    I've tried to be as clear as possible, but let me know if you have questions. Really appreciate it.

    Ian

  2. #2
    Registered User
    Join Date
    07-09-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    38

    Re: Tracing a formula (NOT precedent/dependent tracking, formula audit)

    Select the cell that you want to evaluate. ...
    On the Formulas tab, in the Formula Auditing group, click Evaluate Formula.
    Click Evaluate to examine the value of the underlined reference. ...
    Continue until each part of the formula has been evaluated.
    To see the evaluation again, click Restart.

  3. #3
    Registered User
    Join Date
    06-09-2016
    Location
    nyc
    MS-Off Ver
    2013
    Posts
    2

    Re: Tracing a formula (NOT precedent/dependent tracking, formula audit)

    Thanks A1ksingh - i know about that functionality, but unfortunately that's not quite exactly what I'm talking about. Maybe this feature doesnt exist anymore in E2013..

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Audit Tracking Spreadsheet
    By excelrookie82 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-21-2014, 08:44 PM
  2. [SOLVED] Precedent/dependent arrows will not go away...
    By Wegener in forum Excel General
    Replies: 3
    Last Post: 06-20-2012, 04:30 PM
  3. Formula Precedent changes isn't changing value
    By kevenmicheal in forum Excel General
    Replies: 5
    Last Post: 03-22-2011, 04:54 PM
  4. Precedent and Dependent Arrows
    By raj0102 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-21-2008, 11:56 AM
  5. Moving Between Precedent and Dependent Cells in Excel 2007
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 11-15-2007, 02:52 AM
  6. Trace Precedent and Dependent Cells
    By nicolachen in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-22-2007, 05:42 AM
  7. Replies: 1
    Last Post: 01-28-2005, 01:58 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1