How can I see the column labels when the formula bar expands?

[Guest]

I've got a long formula in a cell that runs over to about 3 lines in the
formula bar. When the cell is selected, the formula bar expands over the
column headsing and some of the top row of cells, obscuring them. Is there
any way to stop this from occurring??

 

[Ragdyer]

A couple of things you can try.

[1]
Hide the formula bar:
<Alt> <V> <F>
Repeat to have it return to view.

[2]
Slightly reduce the size of the worksheet, so that it retracts from the
formula bar:
In the upper right hand corner of the screen, there's 2 sets of controls ( _
 X )
Click on the  of the 2 nd set (second from the top).

 

[Guest]

Thanks RD, option 2 works for me since I still need to see the formula in
that window (trying to check/trace errors). Hadn't thought of the
non-technical solution ;-)

Cheers,
Skiffie.

A couple of things you can try.

[1]
Hide the formula bar:
<Alt> <V> <F>
Repeat to have it return to view.

[2]
Slightly reduce the size of the worksheet, so that it retracts from the
formula bar:
In the upper right hand corner of the screen, there's 2 sets of controls ( _
 X )
Click on the  of the 2 nd set (second from the top).
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

I've got a long formula in a cell that runs over to about 3 lines in the
formula bar. When the cell is selected, the formula bar expands over the
column headsing and some of the top row of cells, obscuring them. Is there
any way to stop this from occurring??

 

[Ivor N]

I've got a long formula in a cell that runs over to about 3 lines in the
formula bar. When the cell is selected, the formula bar expands over the
column headsing and some of the top row of cells, obscuring them. Is there
any way to stop this from occurring??

 

[Ivor N]

I've got a long formula in a cell that runs over to about 3 lines in the
formula bar. When the cell is selected, the formula bar expands over the
column headsing and some of the top row of cells, obscuring them. Is there
any way to stop this from occurring??

Insert a rectangle from the Drawing toolbar, and "copy" your formula on to
it. You can drag it close to the cell in question and examine the cell in
detail. You can also put markers or spaces into the boxed version to help
clarify something with lots of if-then's in it. Make the text bigger too if
it helps. For example (a real one!)

=IF(ISBLANK(H8), IF(OR(ISBLANK(I8),ISBLANK(J8)),"",I8*$Q$3),
IF(OR(ISBLANK(I8),ISBLANK(J8)),"" ,$Q$2+(I8-1)*$Q$3))