When you delete a row in your worksheet, the rows below the deleted row move up to fill the space. When you delete a column, the columns to the right shift left.
Follow these steps to delete a row or column:
Click the row number or column letter of the row or column you want to delete. You can select more than one row or column by dragging over the row numbers or column letters .
Select the Edit menu and then select Delete . Excel deletes the rows or columns and renumbers the remaining rows and columns sequentially. All cell references in formulas and functions are updated appropriately.