Microsoft Office Excel is the most popular spreadsheet editor today, and simple operations with rows and columns (insert, add, copy, move) are its most popular functions. Excel is a very "advanced" editor, so it provides more than one or even two ways to perform such manipulations with table elements.
Necessary
Microsoft Office Excel spreadsheet editor 2007 or 2010
Instructions
Step 1
Click the row heading - a number or an English letter to the left of the first column. This will highlight the line, before which a new blank line will be added. Then right-click on the selection and select "Paste" from the pop-up context menu.
Step 2
You can not select the entire line, but simply right-click any of its cells and select the same "Insert" item in the context menu. However, in this case, you need to do two additional steps - check the box next to the "line" in the "Add cells" window that appears and click the OK button.
Step 3
Use the command sets located in the spreadsheet editor menu as alternative tools for manipulating tables. Having selected any cell in the row, before which you want to add another one, open the drop-down list "Insert" in the "Cells" group of commands on the "Home" tab. Please note that you do not need to click the button itself, but the triangular label placed at its right edge, otherwise the last of the previously used insertion operations will be repeated. In the list of operations in the list, select Insert Row To Sheet.
Step 4
If you need to add one or more existing rows to a certain position of the spreadsheet, not a new one, then start by highlighting them. To copy one line, click on its title, and if there are several of them, do it on the first, and then hold down the Shift key and use the down arrow to extend the selection to the entire range of lines. If these lines should remain in place, press Ctrl + C to copy them. If you need to cut them, use the Ctrl + X combination.
Step 5
Right-click any cell in the row, before which everything you copied or cut in the previous step should appear. In the context menu, select the command "Paste copied cells", and Excel will fulfill your desire.
