Sometimes you might want to leave empty cells within your excel sheet for aesthetic reasons. Having blank cells in the incorrect pace can be undesirable. In this article you will learn how to remove blank cells in Excel.
In a lot of cases, removing empty cells in Excel is simple but in some instances this method is not suitable. Before you carry out the next method of removing cells please ensure you backup a copy of your worksheet.
Once you have carried out your backup in the correct location then you can get started with the following steps to delete empty cells in Excel:
How to remove empty cells in Excel
- Step 1
First you need to select the range where you want to remove the blank cells. You can quickly select all cells with data by clicking the upper left cell and press Ctrl + Shift + End. This will select all data to the last cell used.
- Step 2
Hit F5 on your keyboard and click Special. Alternatively you can go to the Home tab > Formats Group > Find & Select > Go To Special
- Step 3
Click on Go To Special box, select Blanks and click OK. This will then select all the empty cells within the range you selected.
- Step 4
Right click on any of the selected blanks and select delete from the dropdown.
- Step 5
There are two options here and depending on the layout of your data you can select either shift cells left or shift cells up and then click OK. For this example I have selected shift cells left option.
Congratulations, you have now mastered how to remove empty cells in Excel. Your table should now look something like this: