ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   text spilling over text and colums (https://www.excelbanter.com/excel-discussion-misc-queries/64284-text-spilling-over-text-colums.html)

flutterby

text spilling over text and colums
 
My text is spilling over the colums and the text. When I change the view from
70% to 75% the text will not show in the row colums, they go out into the
white area.
If you get this today please feel free to respond. thanks in advanced.


Crypto

text spilling over text and colums
 

Have you tried resizing the column? or perhaps a word wrap?

To resize a column at the top by the letter just click the line in
between and your mouse pointer should change and allow you drag the
column to size. (See pictures 1 and 2)

To use the word wrap feature Right-click on the field and select format
cells, then click on the alignment tab and you should see the option for
word wrap.
(see pictures beforewrap & afterwrap) I hope this helps


+-------------------------------------------------------------------+
|Filename: 1.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=4201 |
+-------------------------------------------------------------------+

--
Crypto
------------------------------------------------------------------------
Crypto's Profile: http://www.excelforum.com/member.php...o&userid=30330
View this thread: http://www.excelforum.com/showthread...hreadid=499914


flutterby

text spilling over text and colums
 
Yes I have tried all of that. can you think of any thing else?

"Crypto" wrote:


Have you tried resizing the column? or perhaps a word wrap?

To resize a column at the top by the letter just click the line in
between and your mouse pointer should change and allow you drag the
column to size. (See pictures 1 and 2)

To use the word wrap feature Right-click on the field and select format
cells, then click on the alignment tab and you should see the option for
word wrap.
(see pictures beforewrap & afterwrap) I hope this helps


+-------------------------------------------------------------------+
|Filename: 1.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=4201 |
+-------------------------------------------------------------------+

--
Crypto
------------------------------------------------------------------------
Crypto's Profile: http://www.excelforum.com/member.php...o&userid=30330
View this thread: http://www.excelforum.com/showthread...hreadid=499914




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

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