ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   letters cut off in cell (https://www.excelbanter.com/excel-worksheet-functions/106024-letters-cut-off-cell.html)

Brian

letters cut off in cell
 
Sometimes when I type a number of letters in a cell, the letters get cut off
at the end of the cell width however sometimes the letters extend into the
next cell and do not get hidden. I do not want to format the cell to wrap
text and I do not want to extend the width of the cell but I would like my
letters to automatically extend across the next cell if necessary so that all
letters are visible. Is there a method to do this? I am not sure why this
works sometimes and not others. Note that the the cells to the right are
blank. Thanks for your help.

Desert Piranha

letters cut off in cell
 

Brian Wrote:
Sometimes when I type a number of letters in a cell, the letters get cut
off
at the end of the cell width however sometimes the letters extend into
the
next cell and do not get hidden. I do not want to format the cell to
wrap
text and I do not want to extend the width of the cell but I would like
my
letters to automatically extend across the next cell if necessary so
that all
letters are visible. Is there a method to do this? I am not sure why
this
works sometimes and not others. Note that the the cells to the right
are
blank. Thanks for your help.Hi Brian,

If the cell to the right is clear (empty) then the text will extend.
If there is something in the cell to the right then the text will stop
at the cell boundry.

The cells may not be empty, they may have formula or special character
in them.

Maybe you could make a new blank column to the right of your data
entrys.


--
Desert Piranha


------------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=573451



All times are GMT +1. The time now is 06:42 PM.

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