Excel 2003-Sp2 - Resize the formula box in the formula bar

Excel 2003-Sp2 - Resize the formula box in the formula bar

Post by news.micro » Fri, 27 Apr 2007 19:13:12


Resize annoying formula box, when e.g. Collumn A has very large text in
fields, and the formula field drowp down and covers the 1st row or more.
This were not an issue in Excel 2000 and in Excel 2007 you can hover the
mouse or use CTRL + SHIFT + U and choose number of lines / the height, and
set it back to 1 line.

But in Excel 2003 you are stuck ..... arrrggggg.

In the follow article it is describes how to remedy this in Excel 2007 -
please help with a solution for Excel 2003.

http://www.yqcomputer.com/

/Alex
 
 
 

Excel 2003-Sp2 - Resize the formula box in the formula bar

Post by Dave Peter » Fri, 27 Apr 2007 19:50:24

I think xl95 through xl2003 all behaved the same way.

I hide the formula bar if it's covering too much:
View|uncheck Formula bar
(or alt-V, F using the accelerator keys)

If that doesn't work for me, then I resize the worksheet window so that it's not
full screen within excel. Then I move it (or resize it further) so that that
window is not near the formula bar.




--

Dave Peterson

 
 
 

Excel 2003-Sp2 - Resize the formula box in the formula bar

Post by Bob Flanag » Fri, 27 Apr 2007 22:23:55

You could put the following macro in your personal.xls file and then assign
it to a button. It will toggle the formula bar on and off.

Sub ToggleFormulaBar()
Application.DisplayFormulaBar = Not Application.DisplayFormulaBar
End Sub

Bob Flanagan
Macro Systems
http://www.yqcomputer.com/
Productivity add-ins and downloadable books on VB macros for Excel