Excel 2007 - Stop long text from flowing to blank cell

Hello,

I have some very long text in multiple cells.  I do not want to wrap the text.  I do not want the text to flow through into the adjacent blank cell(s).  How do I prevent the text from flowing outside of its cell?
ChrisIT ManagerAsked:
Who is Participating?
 
ZekalitaCommented:
Mark the column with the text and set row height manually to standard height (12.75).
Then wrap text anyway. The text will wrap but not show more than one line.

0
 
DonkeyOteCommented:
One way might be to filll the adjacent cells with Nulls - eg: =REPT("",1)

(the Nulls would prevent the cell to the left encroaching)
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Good point, Zekalita!
0
 
ChrisIT ManagerAuthor Commented:
That's perfect!  Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.