Empty line in an excel cell
Thread poster: xxxwonita

xxxwonita
China
Local time: 04:29
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。


 

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

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

 

xxxwonita
China
Local time: 04:29
TOPIC STARTER
Thanks a lot! May 7, 2010

Annamaria Amik wrote:

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


It works.


 

Shouguang Cao
China
Local time: 16:29
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.


 

Emma Goldsmith  Identity Verified
Spain
Local time: 10:29
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!


 


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






TM-Town
Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »
SDL Trados Studio 2017 only €435 / $519
Get the cheapest prices for SDL Trados Studio 2017 on ProZ.com

Join this translator’s group buy brought to you by ProZ.com and buy SDL Trados Studio 2017 Freelance for only €435 / $519 / £345 / ¥63000 You will also receive FREE access to Studio 2019 when released.

More info »



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