ALT+ENTER = line break

[Guest]

What can cause the ALT+ENTER to NOT insert a line break? This usually always
works, but when I tried it at one point today it didn't work. I went to a
different cell and it worked, but the one certain cell would not accept the
ALT+ENTER to insert a line break? Is there a format or something that might
cause this?

 

[Guest]

One thing you may check if the wrap text option (format->Cells->Aligment
tab). It has to be checked to show the line break in place; it shouldn't
affect the insert, but it may be worth to try.

Hope this helps,
Miguel.

 

[Guest]

Miguel,

Didn't work. Thanks for trying to help me.

Nyla

 

[Guest]

You are welcome,

It is hard to replicate a problem like that, you are right when you say that
this usually always works.

Miguel.

 

[plettieri]

Did you try copying the format of a cell that works to the cell o
interest that does not work with the ALT+Enter?

plettier

 

[Guest]

Actually, I closed the file and then re-opened it and the ALT+ENTER worked!!
I just couldn't figure out why those few cells wouldn't work -- Yes, there
were more than one! -- and it did seem to be mostly in one column. I even
re-formatted the column, just to make sure the cells were all the same and,
still, some worked and some didn't!! Very bizarre!

They all work now -- after closing and re-opening the file -- so I guess
I'll never know!!

Thanks to both you and Miguel for trying to help me!! I appreciate it!

 

[Guest]

I am having the same problem as Nyla, alt+enter does not insert a line break
as it should, but it does not fix itself -- it seems to be consistently
missing across all spreadsheets, and has been that way for days. Is there a
way of re-setting the alt+enter command to function as it should?

 

[Guest]

I too am having this problem with Excel 2003 ie alt+enter no longer inserts a
line break within a cell. I have tried the MS method of turning off the
computer, but to no avail. It was coincident with importing a numbered list
from the notes page of a powerpoint presntation, but that may be irrelevant.

 

[Dave Peterson]

Are you actually editing that cell when you hit alt-enter?

 

[Guest]

Yes, it doesn't work whetehr the cursor is highlighted in the formula bar or
within the cell. Other commands such as Alt+T work bringing me to the
appropriate menu item. Its very puzzling as I have found the Alt+Enter to be
very handy.

 

[Dave Peterson]

If you select an empty cell, then type an "a", then alt-enter, does it work ok?

I was guessing that you weren't actually editing the cell yet--you had just
selected it.

 

[Guest]

No, unfortunately it doesn't.

If you select an empty cell, then type an "a", then alt-enter, does it work ok?

I was guessing that you weren't actually editing the cell yet--you had just
selected it.

 

[Dave Peterson]

I'm out of any real ideas.

Any chance you have a funny programmable keyboard and some of the keys have been
remapped?

No, unfortunately it doesn't.

 

[Guest]

Thank you for your help. No I don't have a programmable keyboard, its just my
laptop. I did have a problem some time ago when I had my keyboard set on UK
english - that caused a number of keys to be transposed. Its currently on US
which seems to be correct. I have tried an XP reset to a few days ago but
that didn't work. I may have to reinstall Excel - that will be a pain.
Regards

 

[Dave Peterson]

When(!) you find the solution, please post back. Then Google will have the
answer for the next victim!

Thank you for your help. No I don't have a programmable keyboard, its just my
laptop. I did have a problem some time ago when I had my keyboard set on UK
english - that caused a number of keys to be transposed. Its currently on US
which seems to be correct. I have tried an XP reset to a few days ago but
that didn't work. I may have to reinstall Excel - that will be a pain.
Regards