Tag Archives for " hard return "

Weirdly popular post: How to put multiple lines into cells in Microsoft Excel

All of a sudden (and in addition to a surge in site traffic generally), I’m seeing an awful lot of people visiting my post, How to put multiple lines into cells in Microsoft Excel. There must be a lot of people wanting to do this:

A mailing address typed into Excel

Or this:

Text in an Excel cell with line wrap turned on

Hey, I’m always happy to help. Click here for the full tutorial.

24 Reader Question: Getting rid of hard line breaks in pasted text

Reader Benjamin e-mailed me recently from my Ask the Guru page with this request:

I’ve got text (imported badly – I don’t have access to the original source) which is spaced badly in Microsoft Word 2010 — meaning I have to manually cursor + delete then space-bar to put it back together without the green wiggles.It’s time consuming and I would like to know if there is an automated alternative.

I’m sure I’m one of millions who are suffering with this. Can you help us?Benjamin

He attached a Screenr video demonstrating his problem, which immediately made clear what he was up against:

When he says he’s “one of millions who are suffering with this,” I believe him. Because I’m one of them, too. And between the two of us, we might’ve come up with a good solution.

Keep reading →

59 How to put multiple lines into cells in Microsoft Excel

If you use Microsoft Excel to organize data (say, a list of documents being produced), you may have run across The Cell That's Too Small For Its Data.  You know, you've got a bunch of stuff typed into a cell (not because you're rambling, but because you need all that information, dang it), and it just breaks out of the borders of the cell and keeps on going:

Text in an Excel cell not wrapped

And if that's not annoying enough, if you have to type something into the cell to the right, then you've just cut off the last part of that other cell:

Text in an Excel cell that's not wrapped and is cut off

What you want to be able to do is have the information in the first cell wrap so it appears on multiple lines within that cell.  Right?

Here are a couple of different tricks to try:

Keep reading →