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


--
AJ Master
------------------------------------------------------------------------
AJ Master's Profile: http://www.excelforum.com/member.php...o&userid=12386
View this thread: http://www.excelforum.com/showthread...hreadid=473215

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.

AJ Master wrote:
> 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
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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!
==============================================


"AJ Master" <(E-Mail Removed)> wrote
in message news:(E-Mail Removed)...
>
> 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
>
>
> --
> AJ Master
> ------------------------------------------------------------------------
> AJ Master's Profile:
http://www.excelforum.com/member.php...o&userid=12386
> View this thread: http://www.excelforum.com/showthread...hreadid=473215
>

Move everything down a few rows!

Biff

"AJ Master" <(E-Mail Removed)> wrote
in message news:(E-Mail Removed)...
>
> 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
>
>
> --
> AJ Master
> ------------------------------------------------------------------------
> AJ Master's Profile:
> http://www.excelforum.com/member.php...o&userid=12386
> View this thread: http://www.excelforum.com/showthread...hreadid=473215
>

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



AJ Master wrote:

>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
>
>
>
>