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

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

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

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

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

1. Add-Ins for Excel 2003 - Financial Formulas does not download

2. Range.Formula in Excel 2003 gives Error reading formulas just below 1024 bytes

3. Text not visible in cell only in Formula Bar (excel 2003)

4. How can I change the formula bar in excel 2003?

5. Excel formula doesn't work when put in from vba, but the formula works in Excel

6. Excel 2008 Customized tool bar and Formula bar issues

7. cells show formula like in formula bar, rather than result of form

8. Formulas over multiple lines in the Formula Bar

9. hit F2, want the color coded formula to appear in formula bar not

10. Show value, not formula in formula bar

11. formulas not visible in formula bar

12. Formula Bar show the location path file plus the formula

13. Hiding Formulas in Formula bar

14. how do I hide a cell formula from the formula bar

15. Hiding Formulas In Cells Not Formula Bar

3 post • Page:**1** of **1**