How do I get alt+enter to work in Excel 2007?

Question

I know that you can make a new line in a single cell by using Alt+Enter, however this is not working for me. I know my ALT button is working because when I press alt alone it access my menu bar.

again, I know you use Alt+Enter to make multiple lines in one cell, but this shortcut is not working for me. Any help would be greatly appreciated.

Answer 1

Well, you could use this Excel macro...



Public Sub SetMultiLine()

Dim s As String

'get cell text, convert carriage return. to |

s = ActiveCell.Value: s = Replace(s, vbCr, "|")

s = InputBox("Row 1|Row 2|etc...", , s)

'replace all | to Cariage return, store in cell

s = Replace(s, "|", vbLf): ActiveCell.Value = s

End Sub

Answer 2

I don't have Excel 2007 but try Ctrl+Alt+Enter.

Answer 3

you could use a formula instead. Try this,



="Yahoo"&CHAR(10)&"Answer"



then change the cell format to wrap texts. once you do that, you should see it like.........



Yahoo

Answer