stingy cells!!

[katheirne]

Hello, I have usually been able to create my own Excel documents, but I am writing into one that someone has sent me. I can edit the columns that already have text just fine. Now I am trying to insert new text into rows of a column that did not have text and it is putting all the text into the top left cell. I thought merge cells was a way to alleviate this but it is not working in this case. Help! And many thanks!

Katherine (typo in user name, too fast, sorry!)

[starguy]

Hello, I have usually been able to create my own Excel documents, but I am writing into one that someone has sent me. I can edit the columns that already have text just fine. Now I am trying to insert new text into rows of a column that did not have text and it is putting all the text into the top left cell. I thought merge cells was a way to alleviate this but it is not working in this case. Help! And many thanks!

Katherine (typo in user name, too fast, sorry!)

not clear what exactly you want.
may be Alt+Enter would work.
or elaborate more.

Regards

[katheirne]

And writing into a chart/table filled with text. I am trying to insert text into a new column but instead of allowing the text to fill the column, length and width, the text is all scrunching up in one cell.. many thanks.

[starguy]

And writing into a chart/table filled with text. I am trying to insert text into a new column but instead of allowing the text to fill the column, length and width, the text is all scrunching up in one cell.. many thanks.

how do you insert text? do you type or copy paste?
if you type a long text and to show it in multiple lines just press Alt+Enter to break the line and start new.

[oldchippy]

And writing into a chart/table filled with text. I am trying to insert text into a new column but instead of allowing the text to fill the column, length and width, the text is all scrunching up in one cell.. many thanks.

Take a look at Format Cells > Alignment - Text alignment

[katheirne]

That expanded the cell's width and depth, although the text is now continuing
beyond the edge of the column into the other columns, not wrapping to fit the column. How do I do that? Sorry these are such basic questions.

[oldchippy]

Format Cells > Alignment tick wrap text

[starguy]

That expanded the cell's width and depth, although the text is now continuing
beyond the edge of the column into the other columns, not wrapping to fit the column. How do I do that? Sorry these are such basic questions.

right click > Formate cell... under Alignment tab check Wrap text.

Regards.

[katheirne]

All's well now. And sorry so elementary.

[starguy]

All's well now. And sorry so elementary.

no problem. this Forum is also NEW USERS. you're welcome for any question.

Regards.