Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

How does one insert a newline character into a cell of an Excel spreadsheet?

Up until now I have been copying and pasting the newline from a spreadsheet that already has one.

I am using Office 2003 but I hope that the solution will not be version specific.

But there must be a 'proper' way to do it.

share|improve this question
1  

3 Answers 3

up vote 9 down vote accepted

It's Alt+Enter

share|improve this answer

On Mac OS it's Ctrl + Option + Return.

share|improve this answer

An alternative when you need to make a global change of say "." to a newline open the Find and Replace dialog enter "." in the "Find what" box and in "Replace with" press Alt+0010 and click "Replace All"

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.