Fitting text in cell

B

broogle

Hi,
Is there any way that I can prevent a long text to go across to the
next empty cell ?
If the text is longer than the width of the column than the rest of the
text shouldn't be displayed. Is it possible?
I don't want to use text wrap. The only way I can do this is enter a
blank space in the cell next to it but it's not a good practice.

Thanks.
 
J

Jim Rech

I don't think there are any other options than the ones you've considered.

--
Jim Rech
Excel MVP
| Hi,
| Is there any way that I can prevent a long text to go across to the
| next empty cell ?
| If the text is longer than the width of the column than the rest of the
| text shouldn't be displayed. Is it possible?
| I don't want to use text wrap. The only way I can do this is enter a
| blank space in the cell next to it but it's not a good practice.
|
| Thanks.
|
 

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

Fitting long text 9
Excel Typed text appears in wrong cell 0
Is Auto Expansion (i.e., wrap text) of a cell possible when thecell's contents are based on another 2
Highlight text (interior color) 2
wrap text in merge cells 7
Word wrap and height 1
Knowing where text will wrap 3
Macro that will insert a simple text string in top cell of text file 1

Top