Microsoft Excel Tutorial - How to insert Columns and Rows

Insert Columns and Rows

Introduction:

You may find that you need to add a row or column after you've already inserted data into your worksheet. You can easily insert a new row or column wherever you like using Excel's Insert commands. For example, if you need to add a row or column of data in the middle of a table, you could move the existing data by dragging and dropping it to make room for the new row or column. It's faster to insert a new row or column instead.

Step 1: Select the Row

To insert a row, select the row you want to appear below the inserted row (click the row number to select it).

Step 2: Choose Insert

Right-click the selected row and choose Insert on the shortcut menu.

Step 3: A New Row is Inserted

A new row is inserted above the row you selected.

Step 4: Select the Column

To insert a column, select the column you want to appear on the right of the new column (click the column letter to select it).

Step 5: Insert a New Column

Right-click the selected column and select Insert on the shortcut menu. A new column is inserted to the left of the column you selected.

Step 6: Insert Adjacent Rows or Columns

To insert several adjacent rows or columns at one time, select that many rows or columns in the table, right-click the selection, and choose Insert. An equal number of rows or columns is inserted.

Tutorials - Microsoft Excel

Other Services Available

Useful Information