Please follow the steps below to delete cells and shift other cells left:
Step 1: Select the data range that you want to delete;
Step 2: Click the "Home" tab from the ribbon;
Step 3: Click "Delete" in the "Cells" section and click "Delete Sheet Columns" from the drop-down list;
Step 4: Select Shift cells left in the new dialog box.
– An alternative way is to right-click, then select "Delete" from the list, and select "Shift cells left" in the dialog box.