Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
gbwoodman
 
Posts: n/a
Default allow text to overflow into the next cell?

In some forms that I created in Excel, whatever I type flows into the
adjoining cells. Other times, they are hidden by the next cell. I've tried
formatting both the tect cell and the adjoining cells. Also deleting
everything from the adjoining cell. Nothing seems to work. PLease help!
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default allow text to overflow into the next cell?

If there's something in that adjacent cell to the right (even a space character
or an apostrophe), then the cell's text will never overflow to that adjacent
cell.

If the cell is a number, then it won't overflow.

If you have wrap text turned on (format|Cells|alignment tab), then it'll never
overflow to the right.



gbwoodman wrote:

In some forms that I created in Excel, whatever I type flows into the
adjoining cells. Other times, they are hidden by the next cell. I've tried
formatting both the tect cell and the adjoining cells. Also deleting
everything from the adjoining cell. Nothing seems to work. PLease help!


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Wrap text limits in Excel 2003 cell formatting Adelrose Excel Discussion (Misc queries) 1 April 19th 05 07:32 PM
Text wider than one cell is not displayed in the next empty cell Len Pace Excel Discussion (Misc queries) 5 February 18th 05 01:24 AM
Moving text from one cell to another. estaban botas Excel Worksheet Functions 1 December 15th 04 03:04 PM
how to hyperlink text to a cell steve New Users to Excel 1 December 14th 04 09:21 PM
Formatting a cell as "text" in the number catagory. Ed Excel Worksheet Functions 3 December 7th 04 08:12 PM


All times are GMT +1. The time now is 02:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"