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 columns

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 InsertLesson ActionColumns from the menu bar.
  • 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. The Insert dialog box opens.
  • Click Entire Column in the Insert dialog box.
  • A new column is inserted to the left of the existing column.

To insert multiple columns:

  • Select more than one column.
  • Choose a method (menu or shortcut menu) to insert a new column.
  • The number of columns you originally selected are inserted into the spreadsheet.

Observe how the existing column C is moved to column D to make room for a new column (and new content).

Need to insert column into worksheet

Column Inserted