Empty line in an excel cell
Thread poster: xxxwonita
xxxwonita
China
Local time: 03:18
May 7, 2010

I need some empty lines in an excel cell. If I press "Return key", the cursor jumps to the next cell.

What should I do now?

Thanks a lot。


Direct link Reply with quote
 

Annamaria Amik  Identity Verified
Local time: 08:18
Romanian to English
+ ...
Alt + Enter May 7, 2010

Press Alt+Enter, that inserts a new line in a cell.

Direct link Reply with quote
 
xxxwonita
China
Local time: 03:18
TOPIC STARTER
Thanks a lot! May 7, 2010

Annamaria Amik wrote:

Press Alt+Enter, that inserts a new line in a cell.


It works.


Direct link Reply with quote
 

Shouguang Cao
China
Local time: 14:18
Member (2007)
English to Chinese
+ ...
I know another trick. May 7, 2010

I know the trick to search and replace an empty line in an Excel cell...

In the search for field, turn the Numlock on (if it is not). Press down ALT key and type “10″ in the number pad.

In replace with field, enter anything you wish to replace the empty line. Entering nothing will delete all the empty lines.


Direct link Reply with quote
 

Emma Goldsmith  Identity Verified
Spain
Local time: 07:18
Member (2010)
Spanish to English
Thanks Annamaria Sep 29, 2010

I've been searching how to put a list into an Excel cell. Now I can do it with alt+enter.
Thanks!


Direct link Reply with quote
 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

Empty line in an excel cell

Advanced search






SDL MultiTerm 2017
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.

SDL MultiTerm 2017 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2017 you can automatically create term lists from your existing documentation to save time.

More info »
memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search