New to Excel Lots of questions

[TinaDex]

I am using Excel as a worksheet keeping track of 'to do', 'action', 'status' ect. So I am using it for text not formulas. I have been trying to copy and paste from an email to from peoplesoft into a single cell. This is not working, any ideas? If I can get this to work, I will have a spreadsheet showing the contact, account info, what the issue is, what the status is, who to follow thru with contact. I just can't seem to get several lines of text in one cell. Help!

 

[adept]

I would suggest that you would separate your information into several columns.

contact, account info, what the issue is, what the status is, who to follow thru with contact.

Hope that helps.

Craig

 

[TinaDex]

Hi Craig, Yes, it does help, then when i enter 'issue' say in cell B4, it is a full paragraph and it the text continues to b5, b6, b7, b8 ect. I would like the entire paragraph (or text) in one cell, B4-When I try to cut and paste from an email or peoplesoft, the first line starts in b4 then continues down to c4, d4,e4,f4 ect. I just want the entire paragraph in one cell. Any advise would be greatly appreciated. Thanks, Tina

 

[adept]

When you copy the text that you want. Right click in the cell that you want to paste into and choose Paste Special>Text.

This should paste into the entire cell the information you want.

Craig

 

[adept]

If the information is wider than the width of your cell you can increase the width.

Hover your cursor over the separation line between the two columns and drag to widen the cell.

Craig

 

[adept]

To Wrap the text. Right click the cell, Format Cells.. and click the Alignment tab and check the Wrap Text option.

Sorry, I remember when I didn't know how to do these simple things . You can also Heighten the rows (same as columns).
Craig