Empty line in an excel cell
Thread poster: xxxwonita
xxxwonita
China
Local time: 00:22
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: 06:22
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: 00:22
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: 11:22
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: 05:22
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






Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

More info »
BaccS – Business Accounting Software
Modern desktop project management for freelance translators

BaccS makes it easy for translators to manage their projects, schedule tasks, create invoices, and view highly customizable reports. User-friendly, ProZ.com integration, community-driven development – a few reasons BaccS is trusted by translators!

More info »



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