how do i split subtitles in a single cell?

G

Guest

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
 
B

Bernard Liengme

Try this:
Type the text: This is my top line
Press ALT+ENTER
Type the text: This is second line
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help to create a macro 2
Spliting a cell into two parts 2
Split single cell data into multiple colums 3
Is it possible to split 1 cell into 3 cells w/o affecting other ce 1
how do i use the text in a cell as a named range in a vlookup form 2
How do I split a single cell in Excel ? 2
spread sheet how do you split a cell 4
Color formatting in cell $An 3

Top