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 a row

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 Insert Rows from the menu bar.

    Insert and Rows Menu Selections
  • A new row is inserted above the cell(s) you originally selected.

OR

  • Click anywhere in the row below where you want to insert the new row.
  • Right-click and choose Insert from the shortcut menu.

    Insert Option on Shortcut Menu
  • The Insert dialog box opens.

    Insert Dialog Box
  • Choose the Entire Row button.
  • Click the OK button.
  • A new row is inserted above the cell(s) you originally selected.

    New Row Inserted into Spreadsheet

Select multiple rows before choosing Insert to add rows quickly. Excel inserts the same number of new rows that you originally selected.