Delete Blank Cells and Move Data Left in Excel

If you've ever come across a spreadsheet with empty cells all over it and yearned for a means to clean it up, you've come to the correct place. Delete these blank cells and move the data to the left to improve not just the visual appeal of your spreadsheet but also its usefulness and readability. We will walk you through the process of quickly eliminating empty cells in Excel and rearranging the surrounding data to fill in the gaps in this tutorial. Whether you're a novice or a seasoned Excel user, this tutorial will help you organise your data and streamline your spreadsheet.

Before we get started, it's crucial to remember that this tutorial presupposes a basic understanding of Microsoft Excel. If you're new to Excel, we recommend first becoming acquainted with the software's interface and basic functions. So, let's get started and learn how to get rid of those irritating blank cells and properly rearrange your data in Excel. Prepare to quickly convert your spreadsheets into organised and visually appealing documents!

Deleting Blank Cells and Moving the Data to the Left

Here, we will use the go to special function to complete the task. So let us see a simple process to know how you can delete blank cells and move data left in Excel.

Step 1

Consider an Excel sheet where you have a range of cells with blank cells, similar to the below image.

First, select the range of cells, then use Ctrl + G and click on specials.

Select cells > Ctrl + G > Special.

Step 2

Then click on blanks and click OK to select the range of cells.

Blank > Ok.

Step 3

Then right?click the cells and select delete, then click on shift cell left and click OK to complete the task.

Right click > Delete > Shift cells left > Ok.

Conclusion

In this tutorial, we have used a simple example to demonstrate how you can delete blank cells and move data left in Excel to highlight a particular set of data.