formating text cell paragraphs

[roypea]

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.

 

[Gord Dibben]

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