Sign up ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

This question already has an answer here:

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

marked as duplicate by ChrisF, fixer1234, DavidPostill, JakeGould, BlueBerry - Vignesh4303 Sep 14 at 7:29

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.


3 Answers 3

up vote 10 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

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