How to Remove Cells With No Data in Excel | Scribe

    How to Remove Cells With No Data in Excel

      1
      To begin, open your workbook in Excel.
      2
      Select the empty cell you wish to delete.
      3
      Right-click in the cell to open a menu.\ Click "Delete..."
      Right-click in the cell to open a menu.\
Click "Delete..."
      4
      Select how to shift the cells after you delete the blank cell and click "OK."
      Select how to shift the cells after you delete the blank cell and click "OK."