View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Minitman Minitman is offline
external usenet poster
 
Posts: 293
Default Add A Line In A Text Cell

Greetings,

I need to add a line in a cell being used as a header. There are
three ways to do this:

1) Use Char(10) in a formula - disadvantage is no formatting (Size,
color or font)

2) Use a LOT of spaces - disadvantage is it looks messy and sometimes
does unexpected things.

3) Use some keystroke combination to force a line feed - disadvantage
is you cannot mix text and formulas (I can live with that)..

I am looking for number 3.

Anyone know what that keystroke combination is?

Any help is appreciated, thanks.

-Minitman