answersLogoWhite

0

Press Alt+Enter to add another line within a sincle cell. Type your first line, then press Alt+Enter to move to the second line. In the formula window you will see only the first line unless you use the up and down arrow keys. In the cell you will see both lines. If your lines do not wrap and show up in the cell, format the cell with Cell Wrap turned on.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

When you enter a formula in a cell Excel assigns the cell the same format as the cell reference in the formula?

first


How do I set it up so that the Enter Key does not bring me to a new cell in Excel 2011... I want to continue with writing in the same cell. Clicking on Wrap Text didn't do it.?

Press ALT-Enter to add a new line within a cell.


How do you type a sentence underneath your text in Microsoft Excel?

If you are asking, how do I put a second line in the same cell the answer is: Type the first line of text, the hold down the Alt key and press Enter, i.e. "Alt + Enter". Your cell will now take two lines. You can do this as many times as required.


What press to move to the next line within the same cell?

Pressing the Alt - Enter key combination will start a new line in the same cell.


What allows you to enter a number once in excel and enter it in the same cell on all selected worksheets?

The process you are referring to is called "drilling an entry". Hope this helps :)


How do you enter same value in every cell in Excel in mac entourage?

There is no direct connection between Excel and Entourage, but if you highlight all the cells from Excel and go to Entourage, you should be able to paste the data.


What does the enter box do in Excel?

The Enter box is the green tick that appears beside the formula bar when you are entering or editing a cell. Clicking on it will put what has been typed into the cell. You could just press the Enter key to achieve the same result.


How do you have 3 lines in 1 row in Excel?

If you want 3 lines of text then you can use Wrap Text or press Alt-Enter at the end of each section of text to put it onto a new line in the same cell.


What is the use of shift enter?

Shift-Enter has different uses in different applications. In Excel, when entering something into a cell, pressing Shift-Enter will put the value into the cell and move to the cell above the active cell. If a number of cells have been selected at the time, then it will go to the previous cell. In Word it will start a new line, but keep the subsequent text as part of the same paragraph. This can be useful for things like addresses, where there are multiple lines, but you want to treat it as a single unit. Pressing Enter would make each line a separate paragraph. It is sometimes referred to as a soft return.


IN Excel Why control enter when just enter works?

Control Enter can do a few special things. It will stay in the same cell after you've pressed it instead of moving to another cell. This can be useful if you keep wanting to change the value in the same cell. A really good thing it can do is enter data into multiple cells. If you select a group of cells and type something into the active cell and then press Control Enter, it will enter what you type into the selected cells. You can use that to put the same value into a load of cells at once. You can also use it to enter formulas that you would normally enter into one cell and then copy to the other cells.


Can you use a letter in an Excel cell to represent a number value?

Yes. Excel does not do this directly, but there are several ways to create the effect.EXAMPLE: You want to write the forumua =A+B and show a result of 10.In cell A1, enter 4. Give cell A1 the name "A" (how to do this is another question)In cell A2, enter 6. Give cell A2 the name "B"In cell A3, enter the formula =A+B and observe that the cell displays 10.The reason this works, is because it is the same as =A1+B1 (you just gave the cells different names for Excel to use).If you ask the question again, with specific information about what you are trying to accomplish, you will get a more useful answer.


What command do you use to display text on two lines within a cell?

To display text on two lines within a cell in most spreadsheet programs like Microsoft Excel or Google Sheets, you can use a keyboard shortcut. After typing the text you want in a cell, press "Alt + Enter" to move to the next line within the same cell.