Inserting and Deleting Rows and Columns

Basic formatting in Excel can customize the look and feel of your Excel spreadsheet. Learn about inserting and deleting rows and columns here.

Inserting rows

You can insert a row in a spreadsheet anywhere you need it. Excel moves the existing rows down to make room for the new one.

To insert a row:

  • Click anywhere in the row below where you want to insert the new row.
  • Choose InsertLesson ActionRows from the menu bar.
  • A new row is inserted above the cell(s) you originally selected.

OR

  • Click in the row below where you want to insert the new row. A cell in the row will be selected.
  • Right-click and choose Insert from the shortcut menu. The Insert dialog box opens.
  • Choose Entire Row, then click OK.
  • A new row is inserted above the cell(s) you originally selected.

Important pointTo quickly insert a row or column, select the row or column heading. Right-click to open the shortcut menu and add a new row.

In the image below, see how the existing row 16 is moved to row 18 after a new row is inserted.

Need to insert rows

Rows inserted