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 column

In Excel, you can insert a column anywhere you need it. Excel moves the existing columns to make room for the new one.

To insert a column:

  • Click anywhere in the column where you want to insert a new column.
  • Choose Insert Columns from the menu bar.

    Insert and Columns Menu Selections
  • A new column is inserted to the left of the existing column.

OR

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

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

    Insert Dialog Box
  • Click the Entire Column button in the Insert dialog box.
  • Click the OK button.
  • A new column is inserted to the left of the existing column.

    Column Inserted into a Spreadsheet

You can also select multiple columns before choosing Insert to add columns quickly. Excel inserts the same number of new columns that you originally selected.