Inserting and Deleting Rows and Columns

Basic formatting in Excel XP 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 InsertColumns 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 Entire Column in the Insert dialog box.
  • Click OK.
  • 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 you originally selected.