Excel question?

Question

Hi all, help please how to type a text in a few rows in one cell only. if you know what I mean.
Thanks in advance!

Thanks a lot, I've done it now. Have a good evening everyone.

Answer 1

When you get to the end of one row and want to move down to the next row you hold down the Alt button then hit the enter key, this does a 'soft carriage return' so you can continue typing into the same cell.

Answer 2

Just start typing, text will usually overflow to the next cells to display but the text is all in one cell. Other than that you would need to be more specific and provide better details about what you are trying to do.

Answer 3

Select the cell, then choose (from the menu bar):
Format,
Cells,
Align

and tick the option for 'word wrap', followed by OK.

The text that you type in the cell with wrap around to the next line(s).

Answer 4

click on the cell(s) that you want and press control and the number 1...

then on the 'alignment' tab, check the 'wrap text' box.

that should do it....

you can type in the cell and it will move to the next line.

can also press alt & the enter key while typing.

Answer 5

Select the cells that you want to write in, right click and select 'merge cells'. Alternatively, press ctrl1, click the alignment tab and select 'wrap text'. One of these should answer your question.

Answer 6

Yes, I know what you mean.
1. Type in your text
2. Right click the cell
3. Select Format Cells
4. Click the "Alignment" tab
5. Click the box marked "wrap text."

Answer 7

Alt & return (enter) together!!

Take no notice of the ones telling you to merge cells coz you lose a line of text that way!!

Answer 8

type it all in the one cell and then go to

format (on the toolbar)> cells > alignment> wrap text

Answer 9

select several rows and column of cells.

format - cells - merge cells - wrap around.

hope this helps.

mg

Answer 10

type them in different cells first, then merge cells