ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Expanding Formula Bar (https://www.excelbanter.com/excel-discussion-misc-queries/61854-expanding-formula-bar.html)

Domingo

Expanding Formula Bar
 

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: http://www.excelforum.com/member.php...o&userid=29891
View this thread: http://www.excelforum.com/showthread...hreadid=495992


Chip Pearson

Expanding Formula Bar
 
Unfortunately, this cannot be done.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Domingo"
wrote in message
...

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:
http://www.excelforum.com/member.php...o&userid=29891
View this thread:
http://www.excelforum.com/showthread...hreadid=495992




Ragdyer

Expanding Formula Bar
 
BUT ... to easily toggle the formula bar off and on,
Think - View Formula -
<Alt <V <F

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Chip Pearson" wrote in message
...
Unfortunately, this cannot be done.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Domingo"
wrote in message
...

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:
http://www.excelforum.com/member.php...o&userid=29891
View this thread:
http://www.excelforum.com/showthread...hreadid=495992





Gord Dibben

Expanding Formula Bar
 
Domingo

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

WindowNew WindowArrangeHorizontal.

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
wrote:


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

Expanding Formula Bar
 

:) Thank you all


--
Domingo
------------------------------------------------------------------------
Domingo's Profile: http://www.excelforum.com/member.php...o&userid=29891
View this thread: http://www.excelforum.com/showthread...hreadid=495992



All times are GMT +1. The time now is 08:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com