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."