How to Delete Blank Cells and Shift Data Left in Excel (3 Methods)

If you want to Delete Blank Cells and Shift Data Left in Excel, this article will be very helpful for you. Here, we will walk you through 3 effective methods which will help you to delete blank cells in and shift data left.

Download Workbook

3 Methods to Delete Blank Cells and Shift Data Left in Excel

Here, the following Student Information table has several blank cells. We will use 3 different methods. Here, we used Excel 365. You can use any available Excel version.


Method-1: Using Go To Special Feature to Delete Blank Cells and Shift Data Left

In this method, we will use Excel Go To Special feature to delete the blank cells and shift the data toward left.

➤ First of all, we will select the entire dataset.

➤ Here, we select the dataset from B3 to G13. You can select cell B3 and use keyboard shortcut CTRL+SHIFT+END to select the entire dataset.

How to Delete Blank Cells and Shift Data Lest in Excel

➤ Now, we will type CTRL+G. A Go To window will appear.

➤ From that window, we will select Special.

After that, a Go To Special widow will appear.

➤ We will select Blanks, and click on OK.

Now, we can see the highlighted blank cells in our table.

How to Delete Blank Cells and Shift Data Lest in Excel

➤ Now, we will right click on any of these blank cells, and we will select the Delete option.

➤ Now, we will select Shift cells left.

➤ Then, click on OK.

Finally, we can see that all the blank cells have been deleted, and the cells are shifted left.

How to Delete Blank Cells and Shift Data Lest in Excel


Method-2: Using Find and Select Option

In this method, we will use the EXCEL Find and Select option to delete blank cells and shift data left.

➤ First of all, we will select the dataset from cell B3 to cell G13.

How to Delete Blank Cells and Shift Data Lest in Excel

➤ After that, we will go to the Home tab in the ribbon, and we will select the Editing option.

➤ Then, we will select the Find and Select option.

➤ Then, we will select Go To Special option.

➤ We will select Blanks, and then, click on OK.

We can now see the highlighted blank cells.

➤ Now, we will right-click on any of these blank cells, and we will select the Delete option.

➤ Now, we will select Shift cells left.

➤ Then, click on OK.

Finally, we can see that all the blank cells have been deleted, and the cells are shifted left.

How to Delete Blank Cells and Shift Data Lest in Excel


Similar Readings


Method-3: Delete Blank Cells along the Rows or Columns Manually

In this method, we can manually delete each blank cell and shift the data left.

➤ To do so, first of all, we have to right click on a blank cell.

➤ Here, we right click on cell B4, and after that, we click on Delete.

➤ After that, we will select the Shift cells left option, and click on OK.

Finally, we can see that the data which was on the right side of cell B4 has been shifted left to cell B4.

How to Delete Blank Cells and Shift Data Lest in Excel

In the same way, we can manually delete all the blank cells and shift the data left.

We can see from the following picture that there are no blank cells in the Student Information table.

How to Delete Blank Cells and Shift Data Lest in Excel

Read More: How to Delete Empty Rows and Columns in Excel VBA (4 Methods)


Conclusion

Here, we tried to show you some simple, easy, and effective methods that will help you to Delete Blank Cells in Excel and Shift the Data Left. We hope you will find this article helpful. If you have any queries or suggestions, please feel free to know us in the comment section.


Related Articles

Afia

Afia

Hello, I am Afia Aziz Kona. I graduated in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology (BUET). I have an immense interest in technical writing and content development, therefore, I am working as a content developer at Exceldemy. In my spare time, I travel, watch movies, and cook different dishes.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo