Free Tutorials & Solutions

Learn tricks of professional translators. Get know translation tools and translate more efficiently. Became a translator with a future.


Excel — line breaks in cells

Summary

Cells in Excel sheets can contain more than one text line. We show how to insert them to the cells and how to copy Excel tables to Microsoft Word and back.

Video Transcript

How to translate cells with more than one text line

Sometimes cells in Excel contain more than one text line

If you translate such Excel sheets, for example, by putting in the translation next to the source columnyou will have to insert line breaks into the cells.

In such case you have to use the keyboard shortcut [Alt]+[Enter]

Sometimes, we copy Excel tables to Microsoft Word where we can translate them more comfortably.

But again, if they contain line breaks we will encounter problems when we'll try to copy the translated table back to the Excel.

Cells with line breaks will spread into more separated cells.

That's how to avoid it!

First, you have to replace all manuall line breaks in Microsoft Word into a string that probably doesn't exist in the text let's say, double slash //

Run the command Find and Replace and change manual line break to the string.

Copy the table to Excel and run the command Find and Replace again.

Insert double slash into the first field and click the second field.

Now, you have to use keyboard shortcut [CTRL]+[J] to insert the sign for the proper Excel line break.

If you click Replace All button all occurrences of double slash will change into Excel proper line breaks.

That's it!


Computers & Co.

Translation solutions related to various applications: text editing, DTP, data bases and web sites.

CAT tools

What is computer assisted translation and what are CAT tools. How to use them properly to achieve higher efficiency.

Tips & Tricks

Learn tricks and solutions you may need when you come across problems before, during or after translation.