long formula obscures cell view

I have a workbook with very long formulas (basically external links to
several other workbooks). As a result, when I point to a cell containing such
a formula, the multi-line formula description drops down and obscures the
contents of the cell. I presume that there is a way to prevent that from
happening, but I couldn't find it in Tools>Options

You can hide the Formula Bar under View > Formula Bar, or
do it under Tools > Options > View.

HTH
Jason
Atlanta, GA

>-----Original Message-----
>I have a workbook with very long formulas (basically
external links to
>several other workbooks). As a result, when I point to a
cell containing such
>a formula, the multi-line formula description drops down
and obscures the
>contents of the cell. I presume that there is a way to
prevent that from
>happening, but I couldn't find it in Tools>Options
>.
>

Maybe you could temporarily hide that formula bar:

View|uncheck formulabar
or using the shortcuts: alt-v,f

Or maybe make the worksheet window a little smaller so that it doesn't fight
with the formula bar.



KG wrote:
>
> I have a workbook with very long formulas (basically external links to
> several other workbooks). As a result, when I point to a cell containing such
> a formula, the multi-line formula description drops down and obscures the
> contents of the cell. I presume that there is a way to prevent that from
> happening, but I couldn't find it in Tools>Options

--

Dave Peterson

There is no perfect way to do this, because I need to see the formula bar as
well as the cell itself. Temporarily hiding the formula bar seems to be the
best compromise. Thanks for the suggestions!

"Dave Peterson" wrote:

> Maybe you could temporarily hide that formula bar:
>
> View|uncheck formulabar
> or using the shortcuts: alt-v,f
>
> Or maybe make the worksheet window a little smaller so that it doesn't fight
> with the formula bar.
>
>
>
> KG wrote:
> >
> > I have a workbook with very long formulas (basically external links to
> > several other workbooks). As a result, when I point to a cell containing such
> > a formula, the multi-line formula description drops down and obscures the
> > contents of the cell. I presume that there is a way to prevent that from
> > happening, but I couldn't find it in Tools>Options
>
> --
>
> Dave Peterson
>

KG,

Insert a few extra (empty) rows at the top of the sheet.

Jack Sons
The Netherlands

"KG" <[email protected]> schreef in bericht
news:[email protected]...
>I have a workbook with very long formulas (basically external links to
> several other workbooks). As a result, when I point to a cell containing
> such
> a formula, the multi-line formula description drops down and obscures the
> contents of the cell. I presume that there is a way to prevent that from
> happening, but I couldn't find it in Tools>Options

KG

Work-around could be to enter a Window>Split at say A5. Select your cell
with the long formula in the lower part of the split window. The text in the
formula bar would cover just the top part of the split window.

Alternative.........reduce the size of the sheet window and move it down far
enough to be below the extent of the formula bar.


Gord Dibben Excel MVP

On Tue, 29 Mar 2005 18:37:58 -0800, "KG" <[email protected]> wrote:

>There is no perfect way to do this, because I need to see the formula bar as
>well as the cell itself. Temporarily hiding the formula bar seems to be the
>best compromise. Thanks for the suggestions!
>
>"Dave Peterson" wrote:
>
>> Maybe you could temporarily hide that formula bar:
>>
>> View|uncheck formulabar
>> or using the shortcuts: alt-v,f
>>
>> Or maybe make the worksheet window a little smaller so that it doesn't fight
>> with the formula bar.
>>
>>
>>
>> KG wrote:
>> >
>> > I have a workbook with very long formulas (basically external links to
>> > several other workbooks). As a result, when I point to a cell containing such
>> > a formula, the multi-line formula description drops down and obscures the
>> > contents of the cell. I presume that there is a way to prevent that from
>> > happening, but I couldn't find it in Tools>Options
>>
>> --
>>
>> Dave Peterson
>>