Excel question, when i type in a cell and when l press enter it goes to the next cell.?

Question

How do l start typing at the top of the cell so it doesnt go into the next cell. l have been sent a email from my teacher and l have to put information into the cell, when l type it starts at the bottom and goes across to the next cell. l want to type into the same cell? what do i do?

Answer 1

Right click, go to format cells and change the alignment. If you want to enter inside a cell, press Alt and Enter. When you're finished and the cell is too small for the data you typed in, go to the top of the row (Where the letter is) and double click the cell on the line between rows. The cells are supposed do get bigger so all the words can fit into it.  

Answer 2

dont press enter, just make the cell the height and width you want. format the cell to wrap text.

Answer 3

Good lord, don't do the wrap thing using spaces and tabs to format your cell !!!!

If you want to add another line of text inside the same cell just hit alt-enter instead of enter and continue typing.

Wrap works fine in most cases but if you have a specific format (maybe an address that needs to fit in 1 cell) then use alt-enter to go to the next line in the same cell.

Answer 4

I don't understand what you really want to ask unless I see your Excel sheet, unless you send it to me so I can troubleshoot for you.  Maybe it's too personal but hope this helps:

1)  Try right clicking on the cell and press insert.

or

If you want to type on the same cell

1)  Adjust your margins. or

2)  Rigth click on the cell and go to "Format cells", choose "Alignment" then check the "Wrap Text".

3) If not Merge the cells Blacken the cell of your choice and go to:

"Format Cells" choose "Alignment" then check the "Merge cell).

If this didn't answer your question please clarify.

Thanks

Answer 5

place your curser inside the cell. RIght click and select format from the menu. look for the tab labeled "Alignment" and select "Wrap text"

Answer 6

Excel is a tricky program to use! Here's what you do.

Type all the text you want to put in the cell (if it's long, it will go over, don't worry!)

Then, at the top of the column (where it says the letters) double click on the bar separating the letter of the column you were typing in and the column to the right of it.

This should make the column automatically stretch to fit the size of the text. If it doesn't...

You can drag the column to make it bigger by putting the mouse over the same line as before (when you had to double click) and clicking and dragging to the right to extend the size.

As for the question about the enter key, that's just the way excel is. It's just another confusing this you have to get used to!!

Hope this helps.

Answer 7

Go to "Format" at the top of the screen, click on "Cells," click on the Alignment tab, check the box that says "Wrap text."  Don't press enter when you are typing, the text will automatically go to the next line.