View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
SVC
 
Posts: n/a
Default Excel Formatting question

You can force the text to start a new line where you want it to by using Alt
+ Enter--this is the equivalent of a carriage or paragraph return. Then,
when you expand the column, the text will remain split.

"Smirky73" wrote:

I am setting up an excel spreadsheet. I want 1 cell (Title Cell) to have
wrapped text centered, however I want the remaining cells in that column to
be wider, so all the information shows. When I enlarge the remaining
columns, of course the title cell also widens and the information is no
longer wrapped.

Any assistance would be greatly appreciated.
Thank you!