Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 19
Default INDENT TEXT IN A CELL

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,339
Default INDENT TEXT IN A CELL

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default INDENT TEXT IN A CELL

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 19
Default INDENT TEXT IN A CELL

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel should have a hanging indent for long text entries kxxxk Excel Discussion (Misc queries) 4 November 4th 09 02:00 PM
Filter text in a column by its Indent, to remove certain text 99TZ250 Excel Discussion (Misc queries) 1 May 21st 06 08:53 AM
How can I remove an indent within a cell? DB--less than excel expert Excel Discussion (Misc queries) 5 February 17th 06 08:15 PM
Can you use a hanging indent in an Excel cell? DBTI Excel Discussion (Misc queries) 1 July 8th 05 09:08 PM
Indent within a row marilyn Excel Worksheet Functions 3 May 5th 05 05:50 PM


All times are GMT +1. The time now is 11:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"