Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formating excel multiple paragraphs and colums using one source of data | Charts and Charting in Excel | |||
formating cell with TEXT data type | Excel Discussion (Misc queries) | |||
How can I enter multiple paragraphs in a single Excel cell? | Excel Discussion (Misc queries) | |||
Separate Paragraphs in a cell? | Excel Discussion (Misc queries) | |||
how can i make paragraphs in side one cell in Excell? | Excel Discussion (Misc queries) |