how to stop long formulas from obscuring column letters?
 

how do I vertically enlarge the formula window, so that when i click on a
cell with a long formula in it, the formula doesn't cover up the column
headers?

how to stop long formulas from obscuring column letters?
 

Maybe you could just hide the formula bar.
View|Uncheck Formula Bar

Or maybe you could resize the window so that the column headers aren't so close
to the formula bar.



GoBobbyGo wrote:

how do I vertically enlarge the formula window, so that when i click on a
cell with a long formula in it, the formula doesn't cover up the column
headers?

--

Dave Peterson

how to stop long formulas from obscuring column letters?
 

This is not available pre 2007. The new version has this functionality. If
you don't want to see the formula at all, you can mark the cell formula as
hidden in FormatCells...Protection and protect the sheet

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"GoBobbyGo" wrote in message
...
how do I vertically enlarge the formula window, so that when i click on a
cell with a long formula in it, the formula doesn't cover up the column
headers?

how to stop long formulas from obscuring column letters?
 

Hi

I use a small macro to shrink the size of the sheet so the long formulae
don't overlap my cells.
It is a toggle, so invoking it again switches the sheet back to normal
state.
I have placed a button on my toolbar and attached the macro to it, so it
is very easy to switch states.

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


You can copy the code and paste it into your Visual Basic Editor
(VBE) in a Standard Module located in your file.
To do this,
Alt + F11 (open VBE)
Ctrl + R (open Project Explorer)
Select the file name on the left
Insert Module
Paste code in Module

For more help on writing and inserting macros, David McRitchie has lots
of useful help on his site at
http://www.mvps.org/dmcritchie/excel/install.htm
http://www.mvps.org/dmcritchie/excel/getstarted.htm


--
Regards

Roger Govier


"GoBobbyGo" wrote in message
...
how do I vertically enlarge the formula window, so that when i click
on a
cell with a long formula in it, the formula doesn't cover up the
column
headers?

how to stop long formulas from obscuring column letters?
 

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

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

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

WindowNew WindowArrangeHorizontal.

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 Tue, 19 Dec 2006 14:39:01 -0800, GoBobbyGo
wrote:

how do I vertically enlarge the formula window, so that when i click on a
cell with a long formula in it, the formula doesn't cover up the column
headers?

Gord Dibben MS Excel MVP