close

Hi,

Wonder if anybody can tell me how to expand the formula bar to
accomodate large formulas without blockink the vew of column headers...--
Domingo
------------------------------------------------------------------------
Domingo's Profile: www.excelforum.com/member.php...oamp;userid=29891
View this thread: www.excelforum.com/showthread...hreadid=495992Unfortunately, this cannot be done.--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.comquot;Domingoquot; gt;
wrote in message
news
gt;
gt; Hi,
gt;
gt; Wonder if anybody can tell me how to expand the formula bar to
gt; accomodate large formulas without blockink the vew of column
gt; headers...
gt;
gt;
gt; --
gt; Domingo
gt; ------------------------------------------------------------------------
gt; Domingo's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29891
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=495992
gt;
BUT ... to easily toggle the formula bar off and on,
Think - View Formula -
lt;Altgt; lt;Vgt; lt;Fgt;

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
quot;Chip Pearsonquot; gt; wrote in message
...
gt; Unfortunately, this cannot be done.
gt;
gt;
gt; --
gt; Cordially,
gt; Chip Pearson
gt; Microsoft MVP - Excel
gt; Pearson Software Consulting, LLC
gt; www.cpearson.com
gt;
gt;
gt; quot;Domingoquot; gt;
gt; wrote in message
gt; news
gt; gt;
gt; gt; Hi,
gt; gt;
gt; gt; Wonder if anybody can tell me how to expand the formula bar to
gt; gt; accomodate large formulas without blockink the vew of column
gt; gt; headers...
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Domingo
gt; gt; ------------------------------------------------------------------------
gt; gt; Domingo's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=29891
gt; gt; View this thread:
gt; gt; www.excelforum.com/showthread...hreadid=495992
gt; gt;
gt;
gt;Domingo

A kludgy work-around............

Windowgt;New Windowgt;Arrangegt;Horizontal.

Arrange top window so's it covers 4 or 5 rows.

Work in the bottom window. Your long formulas will drop down into the top
window when you select a cell in lower window.Gord Dibben Excel MVP
On Sun, 25 Dec 2005 16:33:39 -0600, Domingo
gt; wrote:

gt;
gt;Hi,
gt;
gt;Wonder if anybody can tell me how to expand the formula bar to
gt;accomodate large formulas without blockink the vew of column headers...

Thank you all--
Domingo
------------------------------------------------------------------------
Domingo's Profile: www.excelforum.com/member.php...oamp;userid=29891
View this thread: www.excelforum.com/showthread...hreadid=495992
arrow
arrow
    全站熱搜

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