View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default How do i hide carriage returns?

Format the cells to Wrap Text.

Or get rid of the linefeeds.

EditReplace

what: ctrl + j

with: space or nothing.


Gord Dibben MS Excel MVP

On Fri, 28 May 2010 09:41:01 -0700, TVGuy29
wrote:

How do i hide carriage returns? (the "boxes" behind a line of text)