close

Hi All,

This may not even be worthy of a post but if I have a long formula in a
cell and hit F2 to look at what cells are being referenced the text of
the formula gets in the way.

As a result the referenced cells normally highlighted in the blues and
yellows etc are 99% hidden.

Is there anyway to change the way that the forumla is displayed when I
press F2 so I can see clearly what cells I am referencing or should I
stop complaining and get a life?

Just noticed that one way round it is to resize the rows so I can see
the boxes properly.

Thanks
Garry--
Gazzr
------------------------------------------------------------------------
Gazzr's Profile: www.excelforum.com/member.php...oamp;userid=31075
View this thread: www.excelforum.com/showthread...hreadid=534431I make the worksheet window smaller and move it out of the way.

Gazzr wrote:
gt;
gt; Hi All,
gt;
gt; This may not even be worthy of a post but if I have a long formula in a
gt; cell and hit F2 to look at what cells are being referenced the text of
gt; the formula gets in the way.
gt;
gt; As a result the referenced cells normally highlighted in the blues and
gt; yellows etc are 99% hidden.
gt;
gt; Is there anyway to change the way that the forumla is displayed when I
gt; press F2 so I can see clearly what cells I am referencing or should I
gt; stop complaining and get a life?
gt;
gt; Just noticed that one way round it is to resize the rows so I can see
gt; the boxes properly.
gt;
gt; Thanks
gt; Garry
gt;
gt; --
gt; Gazzr
gt; ------------------------------------------------------------------------
gt; Gazzr's Profile: www.excelforum.com/member.php...oamp;userid=31075
gt; View this thread: www.excelforum.com/showthread...hreadid=534431

--

Dave Peterson

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()