1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Insert Cells into an Excel Worksheet

By

Add Cells to an Excel Worksheet
Insert Cells to an Excel Worksheet

Insert Cells to an Excel Worksheet

© Ted French

Insert Cells into an Excel Worksheet

Having to insert extra cells to an Excel worksheet from time to time is a common practice: data gets forgotten and must be added, space must be made for new data, or existing data gets moved about when the sheet is reorganized.

Whatever the reason, there is, as is the case with all Microsoft programs, more than one way to accomplish the task of inserting cells to an Excel worksheet. These instructions cover how to insert one or more cells to a worksheet by right clicking with the mouse.

Down or to the Right?

When you insert additional cells, the surrounding cells of data are shifted either down or to the right of the insertion point in order to make room for the new cells.

The choice of down or to the right is made in the Insert Cells dialog box.

How many Cells to Insert?

You can insert as many new cells to a worksheet as you need. The number added is determined by the number of cells you highlight before you open the Insert Cells dialog box.

Examples: Inserting Cells into a Worksheet

The examples below first cover inserting first a single cell to a worksheet and then multiple cells.

These examples use the months of the year in cells A1 to C4 for data as seen in the image above. The objective is to add extra cells to make room for the missing months of February, March, and June.

In the process, April will be moved down a row and October will be shifted two columns to the right so that it falls between September and November.

At the end of the tutorial all the names of all 12 months of the year should be present and in their proper order in cells A1 to C4.

Adding the data

Add the following data to the cells indicated.

    Cell Reference              Data
               
               A1                     January
               A2                     October
               A3                     April
               B1                     May
               B3                     July
               B4                     August
               C1                     September
               C3                     November
               C4                     December

Insert a Single Cell to a Worksheet

The first example will insert a single cell to column A in order to make room for the month of March. To do this April will be shifted downward to cell A4.

  1. Click on cell A3 to make it the active cell

  2. Right click on cell A3 to open the right-click menu

  3. Click on Insert in the right-click menu to open the Insert cells dialog box

  4. Click on the Shift cells down option in the dialog box

  5. Click OK to add the one cell to the worksheet and to close the dialog box

  6. Cell A3 should now be blank and April should be located in cell A4

  7. Type March into cell A3

Insert Multiple Cells to a Worksheet

The second example will insert two additional cells to row two in order to make room for February and June in cells A2 and B2. In the process October will be shifted to cell C3.

  1. Drag select cells A2 and B2 in the worksheet to highlight them

  2. Right click on cells B2 to open the right-click menu

  3. Click on Insert in the right-click menu to open the Insert cells dialog box

  4. Click on the Shift cells right option in the dialog box

  5. Click OK to add the two cells to the worksheet and to close the dialog box

  6. Cells A2 and B2 should now be blank and October should be located in cell C3

  7. Type February into cell A2 and June into cell B2

Tutorial Outcome

If the above steps have been followed, the names of all 12 months of the year should now be present in the correct order in cells A1 to C4.

Related Tutorials

©2014 About.com. All rights reserved.