A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Office » General Discussions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How to avoid ...



 
 
Thread Tools Display Modes
  #1  
Old April 30th, 2010, 04:35 AM posted to microsoft.public.office.misc
dingdongdingding
external usenet poster
 
Posts: 12
Default How to avoid ...

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.
  #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.


  #3  
Old April 30th, 2010, 04:47 AM posted to microsoft.public.office.misc
ANONYMOUS[_4_]
external usenet poster
 
Posts: 28
Default How to avoid ...

dingdongdingding wrote:

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.


You can't avoid it but you can click on the edit box and start editing
it if this is what you want to do. This only happens if the cell and
text in question is in Row 1. This is normal especially if you have
large amount of text in the cell.

You can click on the edit box and start editing even if you have very
large edit box due to large amount of text.

hth
  #4  
Old April 30th, 2010, 05:07 AM posted to microsoft.public.office.misc
dingdongdingding
external usenet poster
 
Posts: 12
Default How to avoid ...

I just want to read the spreadsheet... thanks anyway.

On Apr 30, 11:47*am, ANONYMOUS wrote:
dingdongdingding wrote:
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.


You can't avoid it but you can click on the edit box and start editing
it if this is what you want to do. *This only happens if the cell and
text in question is in Row 1. *This is normal especially if you have
large amount of text in the cell.

You can click on the edit box and start editing even if you have very
large edit box due to large amount of text.

hth


  #5  
Old April 30th, 2010, 05:08 AM posted to microsoft.public.office.misc
dingdongdingding
external usenet poster
 
Posts: 12
Default How to avoid ...

I see. So at least I can turn it off. But like you said, it affects
all spreadsheets. But at least I can read my spreadsheet in peace for
a while. Just remember to enable the formular bar again when I need
it. Thanks very much.

On Apr 30, 11:47*am, "Skiffle" wrote:
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.- Hide quoted text -


- Show quoted text -


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:10 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.