Excel 2003: How can multiple lines of text be entered into a single cell.?

Question

Attempting to enter multiple lines into an excel 2003 spreadsheet. If I hit return for the next line, it bumps me out of the cell. If I insert enough spaces it's ok until the cell width changes, then the whole cell screws up.
How can I enter into a cell individual, non-shifting text. For example:

1. I am going crazy

2. Trying to figure this out.

3. And, if I have a really long line I would
like it to wrap like this.

4. And I need the cell above to indent when it wraps to look neat, aligned just under the A in the first word.

5. Thanks

THANK YOU

Answer 1

instead of hitting enter



hit



Alt Enter



hit those 2 keys together, and you wont get bumped out.

the spaces is not a good idea.

hope this helps.



edit-

the example didnt have any indents, but isee what you are saying.



i think you will need the spaces after all.



since its a text only box, it shouldnt have any affect on your excel file. just make sure your print preview looks cool, and it will be ok.

the only time it will ever cause a problem is if you are ever going to have to cut and paste it somewhere other than excel.



edit again

1. yahoo kinda sucks at that.

.........most people put a bunch of dots, and say dots

.........represent spaces



edit-

you probably want to be using word for this.

but since we are in exce heres some ideas.

1. start over on a clean new sheet

2. this might be a rare case where you might want to merge cells

.....2a highlight like 5 cells across

.....2b right click and choose format cells

.....2c in the alignment cells tab choose merge(row&col)

.....2d all you need to do is expand row number 1 height.

3. input all your stuff then do 2d

Answer 2

I am not sure of your alignment, but if you use the word wrap feature, when you have set the width of the cell, I then use the space bar and insert enough spaces, until my next line appears in correct alignment with previous line. can use the spaces to indent all your lines. the only problem is that Excel has a maximum number of characters per cell and space is one of them.



email me with any other details or a sample of your problem, as Yahoo answers formats things differently.

Answer 3

Use the WORD-WRAP formatting function.



MORE: Format + Cells + Alignment + select Text Control box for Text Wrap



Good Luck.

Answer 4

Copy the entire text you want to paste in Excel cell. Go to the destination excel cell. Go to cell editing mode by Pressing F2 key or by double click on that cell, and paste (Ctrl + V) the copied text. Hope this will help

Answer 5

That's an interesting question and I hope you'll get some valuable answers

Answer 6

I'm interested in this as well

Answer 7

ALT+ ENTER is the Best Solution. :))))