Inserting and Deleting Cells

Basic formatting in Excel can customize the look and feel of your Excel spreadsheet. Learn about inserting and deleting cells here.

Inserting a cell

When working in an Excel 2003 worksheet, you may need to insert or delete cells without inserting or deleting entire rows or columns.

To insert cells:

  • Select the location where the new cell(s) should be inserted. It can be a single cell or a range of cells.
  • Right-click, and choose Insert.

    Note: You could also choose Insert Cell on the menu bar.

    Insert Selection on the Shortcut Menu
  • The Insert dialog box opens. Select either:
  • Shift cells right to shift cells in the same row to the right.
  • Shift cells down to shift selected cells and all cells in the column below it downward.

    Insert Dialog Box
  • Choose an option, and click the OK button.
  • Your result displays in the spreadsheet.

    Cell Inserted Into A Spreadsheet

Remember, you can also use the Insert dialog box to insert or delete columns and rows.