Adding multiple lines of text within one cell

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

Is there a way, in excel, to add multiple lines of text to a cell?
For example, I want to add a few bullet points (need hard return) but I want
them to all appear within one cell.

Thanks!
 
not sure about the bullet points bit .. but ALT & ENTER will give you a line
return within a cell.
 
Michael

ALT + 0149 for a bullet then type some text and ALT + ENTER

ALT + 0149 for a bullet then type some more text and ALT + ENTER

ALT + 0149 and on and on.

When you want out just hit ENTER

Format for wrap text and autofit.


Gord Dibben Excel MVP
 
You must log in or register to reply here.

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

cells with one to multiple lines 1
Changing line height within a cell ? 3
Word Removing unwanted "lines" within a MS Word 10 table 1
Removing unwanted "lines" within a MS Word 10 table 2
Splitting up multiple lines in one cell to one line per cell inmultiple cells 5
new line within a cell 2
Populate cell with multiple non-blank text values 3
I need to add multiple cells then subtract them from one cell c4+c6+c7+c9+c10+c11 and subtract them 1

Back
Top