Empty line in an excel cell
Thread poster: wonita (X)

wonita (X)
China
Local time: 01:52
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: 06:52
Romanian to English
+ ...
Alt + Enter May 7, 2010

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

 

wonita (X)
China
Local time: 01:52
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: 12:52
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: 05:52
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






SDL Trados Studio 2019 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2019 has evolved to bring translators a brand new experience. Designed with user experience at its core, Studio 2019 transforms how new users get up and running, helps experienced users make the most of the powerful features, ensures new

More info »
Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »



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