How to avoid ...
in [Microsoft Office]
|
Prev: how do I convert tif images to pdf
Next: Office Small Business 2007 installation problems trying to replace Professional 2007 Trial version
From: dingdongdingding on 29 Apr 2010 23:35 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.
From: Skiffle on 29 Apr 2010 23:47 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" <dingdongdingding(a)yahoo.com> wrote in message news:0e1c0298-8bb6-40d9-82d5-3572a6f52630(a)s36g2000prf.googlegroups.com... > 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. >
From: ANONYMOUS on 29 Apr 2010 23:47 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
From: dingdongdingding on 30 Apr 2010 00:07 I just want to read the spreadsheet... thanks anyway. On Apr 30, 11:47 am, ANONYMOUS <ANONYM...(a)EXAMPLE.NET> 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
From: dingdongdingding on 30 Apr 2010 00:08
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" <skif...(a)doesnt.exist> 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" <dingdongdingd...(a)yahoo.com> wrote in message > > news:0e1c0298-8bb6-40d9-82d5-3572a6f52630(a)s36g2000prf.googlegroups.com... > > > > > 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 - |