 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / August 2007overflow text.
Is there any way to stop text from one cell flowing into blank cells to the right of the cell? > Is there any way to stop text from one cell flowing into blank cells > to the right of the cell? One way: Put a space character in the cell to the right. Another: Set the cell to Wrap Text (Alignment pane of the Formatting Palette, or Format/Cells/Alignment). This will automatically increase your row height, but you can set it back. <snip> > This will automatically increase your row > height, but you can set it back. <snip> ...or, alternatively, you can manually adjust the row height by a hair (or whatever) _before_ entering the content to prevent it from automatically increasing.  SignatureRegards |:>) Bob Jones [MVP] Office:Mac > <snip>> This will automatically increase your row > > height, but you can set it back. [quoted text clipped - 8 lines] > Bob Jones > [MVP] Office:Mac I'm sorry I'm new to Excel, could you please tell me how to do that. I've tried a couple of things and they don't seem to work. Sure - Position your pointer on the separator between two row number headings. The pointer will appear as a crosshair-type & you can drag the separator up/down to change the height of the row. SignatureRegards |:>) Bob Jones [MVP] Office:Mac >> <snip>> This will automatically increase your row >> > height, but you can set it back. [quoted text clipped - 12 lines] > I'm sorry I'm new to Excel, could you please tell me how to do that. > I've tried a couple of things and they don't seem to work. On Aug 17, 10:09 am, "CyberTaz" <typegeneraltaz1ATcomcastdotnet> wrote: > Sure - Position your pointer on the separator between two row number > headings. The pointer will appear as a crosshair-type & you can drag the [quoted text clipped - 20 lines] > > I'm sorry I'm new to Excel, could you please tell me how to do that. > > I've tried a couple of things and they don't seem to work. Thanks. But changing row and column height/width doesn't stop text from flowing from one cell into the next. Not unless the cell is formatted to Allow Text Wrap - that's what prevents the overflow. Manually adjusting the row height prevents the row height from automatically increasing as you enter content into the cell. HTH |:>) Bob Jones [MVP] Office:Mac On 8/18/07 10:28 AM, in article 1187447334.457030.130430@22g2000hsm.googlegroups.com, "M" <mark.business@verizon.net> wrote: > On Aug 17, 10:09 am, "CyberTaz" <typegeneraltaz1ATcomcastdotnet> > wrote: [quoted text clipped - 25 lines] > Thanks. But changing row and column height/width doesn't stop text > from flowing from one cell into the next. > In article <1187276862.750538.294...@r34g2000hsd.googlegroups.com>, > [quoted text clipped - 10 lines] > Format/Cells/Alignment). This will automatically increase your row > height, but you can set it back. Thanks. It works. Not elegantly, but after this is MS. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.