How to make an Excel cell paragraph

Sometimes users of Microsoft Office Excel need to register in one cell of the table array at once several lines of text, making the paragraph. Such an opportunity in Excel can be implemented in several ways using standard program tools. About how to add a paragraph into the MS Excel table cell will be told in this article.

Text Transfer Methods in Tables Cells

In Excel, it is impossible to make a paragraph by pressing the "ENTER" key from the computer keyboard, as in Word. Here it is necessary to use other ways. They will be discussed.

Method 1. Transferring text using alignment tools

The entire text of the entire text of the table array is not equally placed in the entire cell, so it will have to be transferred to another line of the same item. The easiest way to perform the task is divided into the following steps:

1. The left key of the manipulator is to highlight the cell in which the paragraph should be made.

Selection of the desired cell to create paragraph in it

1. Move to the "Home" tab, which is located in the top toolbar of the main program menu.
2. In the "Alignment" section, click on the "Text Transfer" button.

Path to the "Text Transfer" button in Excel. Works in all versions of the program

1. Check the result. After the previous action, the size of the selected cell will increase, and the text in it will be rebuilt into the paragraph, adding to several lines in the element.

Final result. Text in the cell moved to a new line. Method 2. How to make several paragraphs in one cell

If the text prescribed in an Excel array element consists of several offers, they can be divided into each other, starting each offer from a new line. This will increase the aesthetics of the design, the appearance of the plate will improve. To accomplish such a partition, it is necessary to act as follows:

1. Select the desired table cell.
2. View a string to enter formulas on top of the main Excel menu under the area of ​​standard tools. In it, the text of the selected item is entirely displayed.
3. Put the mouse cursor between two text offices in the input row.
4. Switch the PC keyboard to English layout and simultaneously clamp the "Alt + Enter" buttons.
5. Make sure that the proposals were delimited, and one of them moved to the next line. Thus, the second paragraph is formed in the cell.

Creating multiple paragraphs in one cell of the Excel table array

1. Do similar actions with other sentences of prescribed text.

Method 3. Using formatting tools

This method for creating a paragraph in Microsoft Office Excel involves changing the format of cells. To implement it, it is necessary to do simple steps by the algorithm:

1. LKM highlight the cell in which the dialed text is not placed due to large sizes.
2. By any area of ​​the element, you right-click the manipulator.
3. In the opening window of the contextual type, click on the "Cell format ..." item.

Path to the cell format window in Microsoft Office Excel

1. In the formatting menu of the elements that will be displayed after performing the previous manipulation, you need to go to the "Alignment" section.
2. In a new section of the menu, find the "Display" block and put a tick next to the "Transfer according to" parameter.
3. Click on "OK" at the bottom of the window to apply changes.

Action Algorithm in the Alignment tab in the "Cell format" menu on the creation of paragraph

1. Check the result. The cell will automatically select the desired dimensions so that the text does not go beyond its limits, and the paragraph will be created.

Method 4. Application of formula

Microsoft Office Excel has a special formula for creating paragraphs, text transfer to several lines in the table array cells. To fulfill the task, you can use the following algorithm of actions:

1. Select a specific cell of the LKM table. It is important that in initially there was no text and other characters in the element.
2. Manually from the computer keyboard enter the formula "= Catch (" text1 "; symbol (10);" Text2 ")". Instead of the words "Text1" and "Text2", you need to drive concrete values, i.e. Write the required characters.
3. After writing to click on "Enter" to complete the formula.

Application of a special formula for transferring lines to Excel

1. Check the result. The specified text will be located on several cell lines, depending on its volume.

How to extend the formula for creating paragraphs to the desired number of cells

If the user needs to transfer the rows at once in several elements of the table array using the formula discussed above, it is enough to extend the function to the specified range of the cells. In general, the procedure for renewing the formula in Excel looks like this:

1. Select the cell in which the result of the formula is registered.
2. Put the mouse cursor to the lower right angle of the selected item and clamp the LKM.
3. Stretch the cell to the desired number of rows of a table array, without releasing the LKM.
4. Release the left key of the manipulator and check the result.

Conclusion

Thus, the creation of paragraphs in Microsoft Office Excel cells does not cause problems even in inexperienced users. To properly transfer rows, it is important to be guided by the instructions above.

Message as in the Excel cell to make the paragraph appeared first to information technology.