Insert an Entire Row or Column in Excel

It is fairly simple to insert an entire row or column in Microsoft Excel.

---

How To Insert an Entire Row or Column

1. Select the row or column where you want to insert a new row or column.
   
   You can use the column and row heading buttons to select entire columns and rows.
   
   
2. From the shortcut menu for the selection, choose Insert (you also can choose Insert, Rows or Insert, Columns).
   
   You do not need to specify where to shift cells.