Can you keep text from one cell showing over the next cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Frequently I have a lengthy amount of text in a cell, and a blank cell next
to it. I would prefer it if the text did not continue over into the next
blank cell.

I know there is an option for Word Wrap, and this increases the size of the
row. Unfortunately this isn't an option I'd like to take. I also don't want
to shrink the text to fit the cell's column width.

So I'm curious if there is a way to have the text display within its own
cell, and any character that would exceed the cell's column width would hide,
instead of carrying over into the blank cell next to it.
 
Just type a "space" or any other character in the cell just to the right of
the cell containing your text.

Vaya con Dios,
Chuck, CABGx3
 
A single space in the adjacent cell will suppress the text showing in it but
there may be another way …
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text Overwriting next empty cell 2
Column Header 1
keeping text in 1 column 8
Can text too long for cell NOT carry over into cells after it? 2
How do I stop cell contents from spilling into the next cell? 4
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
2007 Excel: text in cell becomes hidden when formatted to wrap tex 0
Date changes to ### when next cell is blank - why? 6

Back
Top