View Single Post
  #2  
Old April 30th, 2010, 04:47 AM posted to microsoft.public.office.misc
Skiffle
external usenet poster
 
Posts: 16
Default How to avoid ...

I believe you are referring to the 'formula bar'. You can't keep it from
expanding. When you select a cell, it is showing you the contents of the
cell. As you mentioned, there are many lines in the cells so it will occupy
a fair amount of space to show those lines.

Your only alternative is to hide the formula bar. To do so, click the
'View' tab at the top of the Excel window and uncheck 'Formula bar". The
formula bar will be hidden for all open documents, not just the active one.

HTH.

Skiffle

"dingdongdingding" wrote in message
...
Hi !

I don't really know how to phrase my question... please bear with
me.
I have some spreadsheet with a lot of lines in the cells. When I
move the cursor across such cell, at the top, the "entry box" will
expand and cover the whole spreadsheet and block the cells.
How can I turn off the "entry box" from expanding ?

Hope I have explain correctly.

Thanks.