formating text cell paragraphs
 

Is there away to automatically apply a format to text cells in a worksheet
simular to the Word, Home/parahraph/indents and Spacing/Spacing function.
This function allows you to add space at the end of a paragraph in Word and
I'd like to have a space automatically added at the bottom of cells filled
with a paragraph of text. This will significantly enhance readiblilty of the
form being produced.

formating text cell paragraphs
 

To add a spare line at the end of each cell. hit Alt + Enter when finished
typing.

You could do this in a helper cell.

=A1 & CHAR(10)

Assuming A1 contains a bunch of text.


Gord Dibben MS Excel MVP

On Tue, 29 Jan 2008 12:28:01 -0800, roypea
wrote:

Is there away to automatically apply a format to text cells in a worksheet
simular to the Word, Home/parahraph/indents and Spacing/Spacing function.
This function allows you to add space at the end of a paragraph in Word and
I'd like to have a space automatically added at the bottom of cells filled
with a paragraph of text. This will significantly enhance readiblilty of the
form being produced.