You will need
  • The table editor Microsoft Office Excel 2007 or 2010.
Running the table editor, load the desired spreadsheet and highlight the rowthat needs to be moved to another location in this table. To do this, click with the left mouse button on the header of the desired number of cells - the cell with the ordinal number placed to the left of the first column.
Cut selected row - press Ctrl + X or click the selection with the right mouse button and select Cut from the context menu.
Highlight the table row to which you want to place a portable line, and re-open the context menu - click the selection with the right mouse button. This time select "Insert cut cells" and the operation of transfer lines is completed.
If required move the line and insert in a location in the text of one cell of a non-printable character "end of line", start with turning on edit mode of this cell. To do this, please highlight and double click the left mouse button or press the F2 key. Then move the input cursor to the required position and press Alt + Enter. The rest of the right of the cursor of the cell text will be moved to the next line.
If necessary, automatically inserts hyphens into all spreadsheet cells that contain text strings that do not fit within the column width, select the entire table, press Ctrl + A. If the text is not placed in all columns and rows to highlight only the desired area of the table. Then on the Home tab in the Excel menu, click "text wrapping" - it is placed in the upper-right corner of the group of commands Alignment.
The same effect can be achieved in another way. After selecting the desired region of the table click the right mouse button and in context menu select line "Format cells". A separate window will appear in which click on the tab "Alignment" and click "word wrap". Then click OK, and the problem will be solved.