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.

Deleting a cell

To physically delete the cell from the spreadsheet:

  • Right-click and choose Delete.

    Delete Selection on the Shortcut Menu
  • The Delete dialog box opens. Select either:
  • Shift cells left to shift cells in the same row to the left.
  • Shift cells up to shift selected cells and all cells in the column above it upward.

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