How can I see the column labels when the formula bar expands? in Excel General Questions  
 |  Edit my Profile  |  Help
 
     
   
 
 
 
Skiffie 6/14/2006 8:28 PM PST
  Question
  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??
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Ragdyer 6/14/2006 8:55 PM PST
  Answer
  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 !
---------------------------------------------------------------------------
"Skiffie" <Skiffie@discussions.microsoft.com> wrote in message
news:7BD14E64-2B62-4449-B4EC-D86C16339710@microsoft.com...
> 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??

 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Skiffie 6/14/2006 9:09 PM PST
   
  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.

"Ragdyer" wrote:

> 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 !
> ---------------------------------------------------------------------------
> "Skiffie" <Skiffie@discussions.microsoft.com> wrote in message
> news:7BD14E64-2B62-4449-B4EC-D86C16339710@microsoft.com...
> > 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??
>
>
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Ivor N 2/1/2009 4:49 AM PST
   
 

"Skiffie" wrote:

> 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??
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Ivor N 2/1/2009 4:57 AM PST
   
 

"Skiffie" wrote:

> 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))
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
  Return to Microsoft Communities  Notify me of replies