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

[news.microsoft.com]

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://office.microsoft.com/en-us/excel/HA100818641033.aspx

/Alex

 

[Dave Peterson]

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.

 

[Bob Flanagan]

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.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel