Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nyla
 
Posts: n/a
Default ALT+ENTER = line break

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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Miguel Zapico
 
Posts: n/a
Default ALT+ENTER = line break

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?

  #3   Report Post  
Posted to microsoft.public.excel.misc
Nyla
 
Posts: n/a
Default ALT+ENTER = line break

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?

  #4   Report Post  
Posted to microsoft.public.excel.misc
Miguel Zapico
 
Posts: n/a
Default ALT+ENTER = line break

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?

  #5   Report Post  
Posted to microsoft.public.excel.misc
plettieri
 
Posts: n/a
Default ALT+ENTER = line break


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



  #6   Report Post  
Posted to microsoft.public.excel.misc
Nyla
 
Posts: n/a
Default ALT+ENTER = line break

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


  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 92
Default ALT+ENTER = line break

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?

  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 124
Default ALT+ENTER = line break

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?

  #9   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default ALT+ENTER = line break

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
  #10   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 124
Default ALT+ENTER = line break

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



  #11   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default ALT+ENTER = line break

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
  #12   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 124
Default ALT+ENTER = line break

No, unfortunately it doesn't.

"Dave Peterson" wrote:

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

  #13   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default ALT+ENTER = line break

I'm out of any real ideas.

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



Charles wrote:

No, unfortunately it doesn't.

"Dave Peterson" wrote:

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


--

Dave Peterson
  #14   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 124
Default ALT+ENTER = line break

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

I'm out of any real ideas.

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



Charles wrote:

No, unfortunately it doesn't.

"Dave Peterson" wrote:

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


--

Dave Peterson

  #15   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default ALT+ENTER = line break

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

Charles wrote:

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

I'm out of any real ideas.

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



Charles wrote:

No, unfortunately it doesn't.

"Dave Peterson" wrote:

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


--

Dave Peterson


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get a line break when using a formula to combine cells TESA0_4 Excel Worksheet Functions 5 May 13th 06 03:15 PM
how do I hit return but stay in the same cell to enter a new line Bijan001 Excel Discussion (Misc queries) 2 December 27th 05 06:07 PM
Insert manual line break in formula 0-0 Wai Wai ^-^ Excel Worksheet Functions 3 December 11th 05 08:10 PM
how do I remove fx from the function line, can't enter data dmdranch New Users to Excel 4 December 3rd 05 07:52 PM
Excel 2004 Mac Version - INSERT LINE BREAK IN INFORMULA Daniel Excel Worksheet Functions 2 August 28th 05 11:34 PM


All times are GMT +1. The time now is 11:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"