1-866-245-5224 sales@keystonelearning.com

Excel 2003: Inserting Rows, Columns & Cells

Excel 2003: Inserting Rows, Columns & Cells

When inserting rows, columns and cells all you really need to remember is that the act of inserting simply “pushes” your data either horizontally or vertically. Inserting rows, columns or cells will not delete any data that currently exists on your worksheet.  Let’s look at the following example:

Figure 6. Inserting Rows & Columns Sample

Let’s address the new column first. In order to add a new column (E: April), you would need to select the Total column. The Total column in the original file was column E, but after the new column was inserted, it was pushed to the right and, as a result, became column F.

So, new columns are inserted to the left of whatever column is selected by default.

Now, let’s look at the new row. In order to add a new row (10: Subscriptions), you would need to select the Telephone column. The Telephone column in the original file was row 10, but after the new row was inserted, it was pushed down and, as a result, became row 11.

So, new rows are inserted above whatever row is selected by default.

Inserting a New Column Using the Menu Bar

     
  1. Select the column that will appear to the right of the new column
     
  2.  
  3. Choose Insert: Columns  from the Menu bar
     

Inserting a New Column Using the Shortcut Menu

     
  1. Select the column that will appear to the right of the new column
     
  2.  
  3. Right-click the selected column heading (letter)
     
  4.  
  5. Choose Insert from the Shortcut menu
     

Inserting a New Row Using the Menu Bar

     
  1. Select the row that will appear below the new row
     
  2.  
  3. Choose Insert: Rows from the Menu bar
     

Inserting a New Row Using the Shortcut Menu

     
  1. Select the row that will appear below the new row
     
  2.  
  3. Right-click the selected row heading (number)
     
  4.  
  5. Choose Insert from the Shortcut menu
     

To insert more than one row or column, simply select more than one row or column. For example, if you want to insert three new columns, before clicking Insert, you would select three existing columns. So, the number of columns or rows you select is equal to the number of new columns or rows you want to insert.

In addition to inserting entire columns and rows, you can also insert individual cells.  The Insert Cells Dialog box can be opened by choosing Insert: Cells from the Insert menu when an entire row or column has NOT been selected.

Figure 7. Insert Cells Dialog Box