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?

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.

"Nyla" wrote:

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?

Miguel,

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

Nyla

"Miguel Zapico" wrote:

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.

"Nyla" wrote:

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?

You are welcome,

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

Miguel.

"Nyla" wrote:

Miguel,

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

Nyla

"Miguel Zapico" wrote:

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.

"Nyla" wrote:

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?

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

plettieri


--
plettieri
------------------------------------------------------------------------
plettieri's Profile: http://www.excelforum.com/member.php...o&userid=34531
View this thread: http://www.excelforum.com/showthread...hreadid=544860

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!

"plettieri" wrote:


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

plettieri


--
plettieri
------------------------------------------------------------------------
plettieri's Profile: http://www.excelforum.com/member.php...o&userid=34531
View this thread: http://www.excelforum.com/showthread...hreadid=544860

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?

"Nyla" wrote:

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?

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.

"Dale" wrote:

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?

"Nyla" wrote:

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?

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

Charles wrote:

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.

"Dale" wrote:

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?

"Nyla" wrote:

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?

--

Dave Peterson

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" wrote:

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

Charles wrote:

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.

"Dale" wrote:

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?

"Nyla" wrote:

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?

--

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.

Charles wrote:

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" wrote:

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

Charles wrote:

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.

"Dale" wrote:

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?

"Nyla" wrote:

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?

--

Dave Peterson


--

Dave Peterson