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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

news.microsoft.com - 26 Apr 2007 11:13 GMT

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

Reply to this Message

Dave Peterson - 26 Apr 2007 11:50 GMT

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.

> 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.
[quoted text clipped - 10 lines]
>
> /Alex

Signature

Dave Peterson

Reply to this Message

Bob Flanagan - 26 Apr 2007 14:23 GMT

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

> 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.
[quoted text clipped - 10 lines]
>
> /Alex

Reply to this Message