ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cell acting funny... (https://www.excelbanter.com/excel-discussion-misc-queries/63508-cell-acting-funny.html)

Roz

Cell acting funny...
 

Hey Ya'll! I have a cell that is merged from 14 rows and 8 columns,
basically the whole sheet of regular size paper, from left to right. I
have 3 paragraphs typed and there is enough room to fit all of the
words. But for some reason, excel is letting the last 29 words keep
going to the right (off the page, behind the other cells), instead of
wrapping as all the other words in this cell did, and as I formatted
this cell to do. Any ideas as to what's going on and how I can fix it?
Thanks in advance.


--
Roz
------------------------------------------------------------------------
Roz's Profile: http://www.excelforum.com/member.php...o&userid=29746
View this thread: http://www.excelforum.com/showthread...hreadid=498690


Dave Peterson

Cell acting funny...
 
Try adding some alt-enters to force new lines within the cell (every 80-100
characters).



Roz wrote:

Hey Ya'll! I have a cell that is merged from 14 rows and 8 columns,
basically the whole sheet of regular size paper, from left to right. I
have 3 paragraphs typed and there is enough room to fit all of the
words. But for some reason, excel is letting the last 29 words keep
going to the right (off the page, behind the other cells), instead of
wrapping as all the other words in this cell did, and as I formatted
this cell to do. Any ideas as to what's going on and how I can fix it?
Thanks in advance.

--
Roz
------------------------------------------------------------------------
Roz's Profile: http://www.excelforum.com/member.php...o&userid=29746
View this thread: http://www.excelforum.com/showthread...hreadid=498690


--

Dave Peterson

Roz

Cell acting funny...
 

Fabulous! I was trying to figure out how to enter within a
cell...alt/enter is the way to go. Problem Fixed! You da man Dave!!


--
Roz
------------------------------------------------------------------------
Roz's Profile: http://www.excelforum.com/member.php...o&userid=29746
View this thread: http://www.excelforum.com/showthread...hreadid=498690


Roz

Cell acting funny...
 

Fabulous! I was trying to figure out how to enter within a
cell...alt/enter is the way to go. Problem Fixed! You da man Dave!!


--
Roz
------------------------------------------------------------------------
Roz's Profile: http://www.excelforum.com/member.php...o&userid=29746
View this thread: http://www.excelforum.com/showthread...hreadid=498690



All times are GMT +1. The time now is 05:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com