total noob excel question

[elskipador]

so i'm working with a spread sheet doc. on openoffice & i need to write multiple paragraphs in one cell & i can't figure it out. it just types one long ass line. how in the hell do i make it type normal paragraphs?

 

[BillSmith]

not an expert but...

Try alt + enter.

I'll call the excel expert in the family and repost if wrong.

G'luck.

 

[sportsluvr]

Shawn, I just checked. It looks like text in boxes can't be bulletted or itemized in Excel whereas a box inserted via Outlook has the paragraph formatting capabilities you want.

I'm thinking that it is just a matter of turning on options somewhere. Not sure how myself.

 

[MikeyRocks]

Right click on the cell, click on "Format Cells", click on the "Alignment" tab up top, and check the box that says "Wrap Text". You will need to hit "Alt+Enter" to start a new paragraph.

 

[JackTheTripper]

+1 for Alt + Enter.

Or with MS office if you type it in Word then copy/paste to Excel it usually keeps the formatting.