Stopping the Fx Window from dropping down when clicking in a cell

[Sara]

Is there a way to keep the Fx window from dropping down when I click on a
cell? It drives me crazy because it blocks headings!!!! I spend a lot of
time clicking in and out of cells to see what I'm doing.

[Gord Dibben]

Sara

That is not the Fx window, it is the contents of the Formula bar.

I assume you mean when you have a lot of text in the formula bar.

Resize the Window so you're not working in a maximized window.

Alternative..........................

A kludgy work-around............

Window>New Window>Arrange>Horizontal.

Arrange top window so's it covers 4 or 5 rows.

Work in the bottom window. Your long formulas will drop down into the top
window when you select a cell in lower window.


Gord Dibben Excel MVP


On Fri, 23 Jun 2006 13:03:02 -0700, Sara <Sara@discussions.microsoft.com> wrote:

>Is there a way to keep the Fx window from dropping down when I click on a
>cell? It drives me crazy because it blocks headings!!!! I spend a lot of
>time clicking in and out of cells to see what I'm doing.

Gord Dibben MS Excel MVP

[SimonCC]

You can't really make the formula bar show less than what's inside the
selected cell. However, if you don't need the formula bar at all, you can
hide it by going to View --> Formula Bar. That will hide both the formula
bar and the name box. Hopefully you won't be needing both.

-Simon

"Sara" wrote:

> Is there a way to keep the Fx window from dropping down when I click on a
> cell? It drives me crazy because it blocks headings!!!! I spend a lot of
> time clicking in and out of cells to see what I'm doing.

[Ragdyer]

See if this old post helps:

http://tinyurl.com/ks64n

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Sara" <Sara@discussions.microsoft.com> wrote in message
news:8ABF0F2A-900C-4850-AA9B-001426640372@microsoft.com...
> Is there a way to keep the Fx window from dropping down when I click on a
> cell? It drives me crazy because it blocks headings!!!! I spend a lot of
> time clicking in and out of cells to see what I'm doing.