L
Lisa D. Parker
I need to know how to do a hard return when typing text into a cell. On a PC
it's supposedly Alt-Enter. But what is it on a Mac?
it's supposedly Alt-Enter. But what is it on a Mac?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Domenic
This should do it:I need to know how to do a hard return when typing text into a cell. On a PC
it's supposedly Alt-Enter. But what is it on a Mac?
Command (Apple) + Option + Enter
Cheers!
T
The Wolf
This should do it:
Command (Apple) + Option + Enter
Cheers!
I had the same question. I want a return or two lines of text in a cell that
is custom formatted to read something like. "Balance Must Be" $# "On The
15th"
Command Option Enter doesn't seem to work.
J
JE McGimpsey
The Wolf said:I had the same question. I want a return or two lines of text in a cell that
is custom formatted to read something like. "Balance Must Be" $# "On The
15th"
Command Option Enter doesn't seem to work.
Make sure the cell is set to Wrap Text
T
The Wolf
Make sure the cell is set to Wrap Text
It is.
The cell is custom formatted to display "Balance Must Be" $# "On The
15th"
Does that matter? I want a return after # so the message will fit in the
box.
B
Bernard Rey
The Wolf wrote :
I'm afraid you can't have it working in a custom format. You can have it
within a formula. Say the expected result is in A1, type:
="Balance Must Be $" & A1 & CHAR(13) & "On The 15th"
If your cell is set to Wrap Text, it should work...
It is.
The cell is custom formatted to display "Balance Must Be" $# "On The
15th"
Does that matter? I want a return after # so the message will fit in the
box.
I'm afraid you can't have it working in a custom format. You can have it
within a formula. Say the expected result is in A1, type:
="Balance Must Be $" & A1 & CHAR(13) & "On The 15th"
If your cell is set to Wrap Text, it should work...