Adding rows to tables created in Excel, included in the Microsoft Office suite, is a standard operation of the application and is performed using standard tools without the involvement of additional software.
Instructions
Step 1
Click the "Start" button to bring up the main OS Windows menu and go to the "All Programs" item to carry out the procedure for adding a row to the selected Excel spreadsheet.
Step 2
Expand Microsoft Office and start Excel.
Step 3
Open the document to be edited and press the Tab softkey in the last cell of the bottom row of the table to add a blank line to the end of the selected table.
Step 4
Enter the required value in the cell immediately below the selected table to add a row, or drag the size pointer in the lower right corner of the table down to add a row using the mouse.
Step 5
Select one or more rows of the table to be added under the desired location and open the "Cells" menu in the top toolbar of the Excel application window.
Step 6
Go to the "Home" tab of the dialog box that opens and expand the "Insert" menu by clicking on the arrow of the selected field.
Step 7
Specify the desired command: - "Insert table rows from above"; - "Insert table rows from below" or call the context menu of the row to be added by clicking the right mouse button to perform an alternative editing procedure.
Step 8
Specify the "Insert" command and select the required action option from the drop-down menu. Another way to perform the desired operation is to use the context menu of one of the cells of the line to be edited, called by the right mouse click, and go to the "Insert" dialog.
Step 9
Use the Ctrl softkey to highlight the non-contiguous rows of the selected table to be edited, and expand the Cells menu in the top toolbar of the Excel window.
Step 10
Go to the "Start Page" tab of the dialog box that opens and select the "Paste" command.
Step 11
Expand the drop-down menu of the selected dialog by clicking on the arrow and select "Insert sheet rows" to add non-contiguous rows to the Excel table.
