Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    London, Middlesex, England
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Highlight Cells referenced to by formula

    Hello,

    In Excel, if I have a formula which refers to many cells, e.g. =SUM (C4+D4+E4),
    then there's an option that when you place the cursor in the cell where the formula is based, a dashed line highlights all the cells referred to in the formula.

    In this case, cells C4, D4 and E4 will be highlighted.

    I used to have that option until recently & now it seems to have switched off.

    How can I switch it back on?!

    BD.

  2. #2
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Highlight Cells referenced to by formula

    Bob,

    Are you placing the cursor in the cell with the formula or on the "formula bar"? Another way to look at it is place the cursor in the cell with the formula and press the F2 function key. Or could you possibly be using the formula audit function: View>Toolbars>Formula Auditing.

    John

  3. #3
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    London, Middlesex, England
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Highlight Cells referenced to by formula

    F2 fixes the problem. Thanks mate.

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Highlight Cells referenced to by formula

    You might also see if Tools | Options | Edit | Edit directly in cell is checked.
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Highlight Cells referenced to by formula

    Are you not maybe refering to the tracer arrors when you adit the formulas.
    Select the cell containing the formula, choose TOOLS | AUDITING | TRACE PRECEDENTS. This shows arrows pointing to all cells used in the formula.

    Sorry, I only notice now that John already refered to that!!!! <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    Regards,
    Rudi

Posting Permissions

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