Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Is there a way to indent only the second line of text in ONE cell without
indenting the first line? Example: Consolidation of Parcels and Boundary Line Adjustments Between Parcels in the RA and RC Zones |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If your example is typical i.e. two lines, the centering the text would give
the same appearance. Othrwise it's all or nothing. "Fran" wrote: Is there a way to indent only the second line of text in ONE cell without indenting the first line? Example: Consolidation of Parcels and Boundary Line Adjustments Between Parcels in the RA and RC Zones |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You could use alt-enter to force a new line within the cell.
Then add a bunch of spaces at the front of the second line. Fran wrote: Is there a way to indent only the second line of text in ONE cell without indenting the first line? Example: Consolidation of Parcels and Boundary Line Adjustments Between Parcels in the RA and RC Zones -- Dave Peterson |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Dave, that works PERFECTLY!!! Thanks so much!!
"Dave Peterson" wrote: You could use alt-enter to force a new line within the cell. Then add a bunch of spaces at the front of the second line. Fran wrote: Is there a way to indent only the second line of text in ONE cell without indenting the first line? Example: Consolidation of Parcels and Boundary Line Adjustments Between Parcels in the RA and RC Zones -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel should have a hanging indent for long text entries | Excel Discussion (Misc queries) | |||
Filter text in a column by its Indent, to remove certain text | Excel Discussion (Misc queries) | |||
How can I remove an indent within a cell? | Excel Discussion (Misc queries) | |||
Can you use a hanging indent in an Excel cell? | Excel Discussion (Misc queries) | |||
Indent within a row | Excel Worksheet Functions |