Strings in the spreadsheet editor Microsoft Office Excel are not always called the same thing that is meant when working with plain text - in this application, such a definition is given to a number of table cells. Therefore, the object of the transfer operation here can be either a horizontal group of table cells or a line of text placed in a separate cell.
Necessary
Tabular editor Microsoft Office Excel 2007 or 2010
Instructions
Step 1
After launching the spreadsheet editor, load the desired spreadsheet into it and select the row that you want to transfer to another place in this table. To do this, left-click on the header of the required row of cells - the cell with the ordinal number of the row, placed to the left of the first column.
Step 2
Cut the selected line - press the key combination Ctrl + X or right-click the selection and select the "Cut" command from the context menu.
Step 3
Select the row of the table in front of which you want to place the line to be wrapped, and reopen the context menu - right-click the selection. This time, select the "Paste Cut Cells" command and the line break operation will be completed.
Step 4
If you do not need to move a line, but insert a non-printable “end of line” character into a specific place in the text of one of the cells, start by turning on the edit mode for this cell. To do this, select it and double-click the left mouse button or press the F2 key. Then move the cursor to the desired position and press the key combination alt="Image" + Enter. Any text remaining to the right of the cursor will wrap to the next line.
Step 5
If you need to automatically insert hyphenations into all cells of a spreadsheet that contain text strings that do not fit into the width of the column, select the entire table - press Ctrl + A. If the text is not located in all columns and rows, you can select only the required area of the table. Then, on the Home tab, on the Excel menu, click the Wrap Text button - it's located in the upper-right corner of the Align command group.
Step 6
The same effect can be achieved in another way. After selecting the required area of the table, right-click it and select the "Format cells" line in the context menu. A separate window will open, in which go to the "Alignment" tab and check the "Wrap by words" box. Then click the OK button and the task will be completed.
