Can you control the size of the formula bar?

A

AJ Master

I have been encountering a problem with the excel formula bar and I
thought I'd see if anyone here knew of a solution.

Some of the formula's in my models can get quite long and when this
happens the formual bar expands to 2 sometimes 3 lines. The problem
with this is that now my column headers (i.e. AA, AB, AC...etc) are no
longer visible. Does anyone know of a way to make sure my column
headers are always visible when the formula bar expands to 2 or more
lines?

Thanks...AJ
 
D

Debra Dalgleish

You can't change the size of the formula bar. You could increase the
height of the first row, so the overflow doesn't cover the data.
 
R

RagDyer

You could toggle the formula bar off and on by:

<Alt> <V> <F>

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
R

Roger Govier

Hi

All of the solutions posted so far are very useful but they don't
overcome your problem of hiding the column letters.

The way I have got around this when necessary, is to choose
Windows>Cascade when you can resize the sheet so that there is a gap at
the top of the frame where your overspill from the formula bar can go,
and you still see the column letters below this.
Obviously you are sacrificing some of your viewable area as far as
overall sheet viewing is concerned.

I recorded a small macro to which I added a shortcut of Ctrl+q, then
whenever I have the problem of formula overrun, I can toggle the screen
between the 2 states.

Sub smallsheet()

If ActiveWindow.WindowState = xlMaximized Then
Windows.Arrange ArrangeStyle:=xlCascade
With ActiveWindow
.Top = 56.5
.Left = -2.75
End With
With ActiveWindow
.Width = 765
.Height = 393
End With

GoTo Finish

End If
ActiveWindow.WindowState = xlMaximized

Finish:

End Sub

I am sure there will be more efficient ways of doing this, but this
simple workaround I find quite useful. You will have to change the
screen settings above to suit your particular requirement.

Regards

Roger Govier
 
Top