Hi Marilyn,
Please don't change the subject line, the proper thing to do is to
start a new question and not by using a reply.
Watch your terminology. Excel has rows and columns, I think you
mean how to start a new line within a cell.
use the Alt+Enter
and if you want to do the equivalent in a formula you would use CHAR(10)
in a concatenation ="line one" & CHAR(10) & "line two"
and in VBA if you start writing macros you would use CHR instead of CHAR.
When people use Google web search or Google Groups search they
look at the subject line when they get hits on words to try to determine
which of many items might be relevant to what they searched for. http://www.mvps.org/dmcritchie/excel/xlnews.htm
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.