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? |
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? |
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? |
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? |
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 |
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 |
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? |
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? |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 08:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com