up vote 0 down vote favorite
share [g+] share [fb]

Is it possible to use the wrap text option in an Excel cell but not have it split words when autoresizing? For example, if I have this text in a cell "This is my column title", it would be okay when I autosized (double click the column border) to have:

This
is 
my
column
title

But not:

This is m
y column t
itle.
link|improve this question
43% accept rate
It should work in all cases except when your column is narrower than a full word. So in your example, I get what you want unless the column is less than 53 pixels wide (using Consolas 11 pt), as "column" is 52 pixels wide, so it has to split the word. – Rhys Gibson Sep 27 '11 at 19:58
I've been doing some playing around and found that it does do what I want (makes the column wider if needed) AS LONG AS the row height forces it to. If the row height will allow for all the contents to be displayed, it won't resize the column width and produces split words. Make the row height smaller and autoresize the column and it works. Not sure if that makes sense; it's hard to describe in words what I mean. – sdoca Sep 27 '11 at 21:37
@sdoca you could post your own answer since it's the the best so far – barlop Sep 27 '11 at 22:42
@RhysGibson But in his example the word "my" got broken..which isn't necessary since it's such a small word. So I suppose as sdoca said that row height is coming into play. – barlop Sep 27 '11 at 22:45
feedback

1 Answer

up vote 0 down vote

In Alignment, click the Wrap Text button.

Demonstration

link|improve this answer
Thanks, but the question is about disallowing the breaking of text in the middle of a word when text wrap is on and autosizing a column, not how to turn on text wrap. – sdoca Sep 27 '11 at 19:47
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.