Inserting and Deleting Cells

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

Inserting cells

When working in an Excel XP 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) will be inserted. It can be a single cell or a range of cells.
  • Right-click and choose Insert.

    Note: You could also choose InsertCell 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, then click OK.
  • 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.