View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default how do i split subtitles in a single cell?

Try this:
Type the text: This is my top line
Press ALT+ENTER
Type the text: This is second line
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"apple1985" wrote in message
...
i need to split a cell in half in order to fit in two titles for an
accountancy sheet e.g
in cell C1 i have:
Other Money Coming In i need to put subtitles underneath that in cell C2:
Cash from Bank | Other