Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get a line break when using a formula to combine cells | Excel Worksheet Functions | |||
how do I hit return but stay in the same cell to enter a new line | Excel Discussion (Misc queries) | |||
Insert manual line break in formula | Excel Worksheet Functions | |||
how do I remove fx from the function line, can't enter data | New Users to Excel | |||
Excel 2004 Mac Version - INSERT LINE BREAK IN INFORMULA | Excel Worksheet Functions |