How To Add A Row To An Excel Table

Table of contents:

How To Add A Row To An Excel Table
How To Add A Row To An Excel Table

Video: How To Add A Row To An Excel Table

Video: How To Add A Row To An Excel Table
Video: Adding Total Row to a Table in Excel 2016 2024, December
Anonim

The procedure for adding a row to a created table in Excel included in the Microsoft Office package may be useful to the user when performing some editing operations. To implement the procedure for adding a line, standard system tools are used.

How to add a row to an Excel table
How to add a row to an Excel table

Instructions

Step 1

Click the "Start" button to bring up the main menu of the system and go to the "All Programs" item to perform the operation of adding a row to a table in the Excel application included in the Microsoft Office package.

Step 2

Run the application and open the table to be edited.

Step 3

Select the last cell of the last row of the table and press the Tab softkey to add a new blank row to the end of the table.

Step 4

Enter the desired value or text in the cell below the table to be edited to add a row, or drag down the table size guide located at the bottom right of the selected table.

Step 5

Select the row above which you want to insert an additional row, and open the "Cells" menu in the top toolbar of the Microsoft Office Excel application window.

Step 6

Select the Insert command and click the arrow next to the command line.

Step 7

Specify the item "Insert table rows from above" to perform the procedure for adding a row, or use the command "Insert table rows from below" to add the required row below the last row of the table.

Step 8

Call the context menu of the table row to be edited by clicking the right mouse button and select the "Insert" command to execute an alternative method of adding a row.

Step 9

Select the desired action in the drop-down list or call the context menu of the cell in the required row by right-clicking and specifying the "Insert" command to use one more way of adding a row.

Step 10

Specify Table Rows Above to perform the selected operation.

Step 11

Select the created new row in the Excel office application table and open the "Cells" menu of the top toolbar of the program window.

Step 12

Select the Delete command and select Delete Table Rows (if necessary).

An alternative method for deleting a created new row can be the use of the "Table Rows" item of the "Delete" command of the context menu of the row, invoked by clicking the right mouse button.

Recommended: