I format the cell as suggested and it works fine now. No F2 needed.
Which version do you have? Do you see that little square that RD mentioned?
Epinn
Epinn wrote:
> > I find that sometimes, I must select the cell and press F2 in order to
> > get the desired effect. I do not know why.
>
> I format the cell as suggested and it works fine now. No F2 needed.
> Which version do you have? Do you see that little square that RD mentioned?
I am using Office Excel 2003; and yes, when the alt-Enter is
ineffective, I see a little square in the text. Perhaps F2 is never
needed when Wrap Text is selected explicitly (checkmarked). But it is
needed occassionally (and seemingly unpredictably) when Excel selects
Wrap Text implicitly -- which is indicated by a solid green box instead
of a checkmark next to Wrap Text under Format > Cells > Alignment.
Excel seems to select Wrap Text implicitly when alt-Enter is typed
initially. Since I cannot cause the alt-Enter to be ineffective
predictably, I do not know if the implicit Wrap Text is deselected when
that happens. But if I deselect Wrap Text explicity (leaving the
option uncheckmarked), the alt-Enter is ineffective, of course.
Pressing F2 causes Wrap Text to be selected implicitly again. So I do
suspect when F2 is needed, it is because Excel had selected Wrap Text
implicitly, then deselected it implicitly for some inexplicable reason.
The point is: If things work fine initially when you type alt-Enter,
then later they do not work, either selecting the cell and typing F2,
or explicitly selecting Wrap Text format should remedy the situation.
joeu2004@hotmail.com - 29 Oct 2006 02:33 GMT
joeu2...@hotmail.com wrote:
> Perhaps F2 is never
> needed when Wrap Text is selected explicitly (checkmarked). But it is
> needed occassionally (and seemingly unpredictably) when Excel selects
> Wrap Text implicitly -- which is indicated by a solid green box instead
> of a checkmark next to Wrap Text under Format > Cells > Alignment.
The green box in the Wrap Text option apparently indicates that Wrap
Text was selected (implicitly) for some, but not all of several cells
that were merged.
When I enter text that contains alt-Enter into a single cell, Wrap Text
is checkmarked automatically by Excel.
My experience has been that such single-cell alt-Enter text does indeed
lose its formatting occassionally and unpredicably. Selecting the cell
and typing F2 (by the way, I really mean F2 Enter) has remedied the
problem when it has happened in the past (just hours ago!).
As an experiment, when I deselect Wrap Text explicitly, Wrap Text
becomes uncheckmarked; then selecting the cell and typing F2 causes
Wrap Text to be selected again.
But once again, because I am unable to predictably cause alt-Enter to
become ineffective automatically (i.e. by Excel, not me) when I have
not selected Wrap Text explicitly, I cannot say with impunity that F2
is needed occassionally when you select Wrap Text explicitly.
You might simply file this information away in the recesses of your
mind, just in case it becomes necessary.
Epinn - 29 Oct 2006 02:41 GMT
I am quite lost with this talk of implicit, explicit, solid green box etc. etc. I only wonder about one thing. Both of us use 2003, how come I don't see a little square with CHAR(10) before format>alignment>wrap text? However, I won't waste time on this and I'll just let it go.
Epinn
Epinn wrote:
> <joeu2004@hotmail.com> wrote:
> > I find that sometimes, I must select the cell and press F2 in order to
> > get the desired effect. I do not know why.
>
> I format the cell as suggested and it works fine now. No F2 needed.
> Which version do you have? Do you see that little square that RD mentioned?
I am using Office Excel 2003; and yes, when the alt-Enter is
ineffective, I see a little square in the text. Perhaps F2 is never
needed when Wrap Text is selected explicitly (checkmarked). But it is
needed occassionally (and seemingly unpredictably) when Excel selects
Wrap Text implicitly -- which is indicated by a solid green box instead
of a checkmark next to Wrap Text under Format > Cells > Alignment.
Excel seems to select Wrap Text implicitly when alt-Enter is typed
initially. Since I cannot cause the alt-Enter to be ineffective
predictably, I do not know if the implicit Wrap Text is deselected when
that happens. But if I deselect Wrap Text explicity (leaving the
option uncheckmarked), the alt-Enter is ineffective, of course.
Pressing F2 causes Wrap Text to be selected implicitly again. So I do
suspect when F2 is needed, it is because Excel had selected Wrap Text
implicitly, then deselected it implicitly for some inexplicable reason.
The point is: If things work fine initially when you type alt-Enter,
then later they do not work, either selecting the cell and typing F2,
or explicitly selecting Wrap Text format should remedy the situation.
joeu2004@hotmail.com - 29 Oct 2006 04:54 GMT
> I am quite lost with this talk of implicit, explicit, solid green box etc.
Sorry about that. I was writing more for the experienced MVP, in the
hopes that someone might be able to explain what __I__ am seeing.
(I was also trying to be helpful to you insofar as giving you a
heads-up about the potential future need to use F2.)
> Both of us use 2003, how come I don't see a little square with CHAR(10) before format>alignment>wrap text?
Hmm, I wonder if there is an option that controls that behavior? None
that I can find. And I __think__, but I cannot be sure, that I also
have not see the little square __sometimes__ when I know that it is
there.
> However, I won't waste time on this and I'll just let it go.
Agreed!