Learn how to remove blank row or empty cell in Excel

Yodalearning>Tutorials>Learn how to remove blank row or empty cell in Excel

How to remove blank row or cell in Excel? confused?

Data doesn’t always import or paste into Excel as nicely as you want. Sometimes, all the information is there, but extra blanks and spaces are carried along with the data cells.

Think that if you work with a large data set in an Excel Workbook or Excel Spreadsheet, there are times you might need to delete a blank cell or set of blank cells. The process can become time-consuming; if you have a lot of data. Instead of going through the workbook, and deleting each blank row or column individually, you can make multiple selections and let Excel do the work for you.

How to remove blank cells in Excel?

Read the blog, to get the ANSWER. Keep reading

We can do it by completing 2 stages:

  • Selecting those blank cells only
  • Deleting those blank cells

So let’s go through the following steps to solve this problem in Excel.

remove blank cells in excel

Step 1: Create a table same as in the picture above which has many unnecessary cells and rows blank. We are going remove those blank cells from this table.

How to remove blank rows in excel

Step 2: Select the whole table and go to Home tab. In the Editing Group click Find and Select.

tips & tricks how to remove blank rows in excel

Step 3: Under Find and Select list click Go To Special.

select blanks

Step 4: Now Go To Special dialog box will appear. Check blanks and click on OK.

after selection

Step 5: After that we can see in our Excel sheet that this method only selected blank cells from our selected range of table.

So our first stage is completed, now let’s go to the second stage and delete these blank cells.

select delete optionStep 6: In our second stage we need to delete only those selected blank cells. Now right-click on the selected cells. The Pop-Up Menu will appear. Select the delete option.

shift cells left

Step 7: Now Delete box will appear. Check Shift cells left to delete columns from the selection. Click OK and see the magic.

Read More: Learn Online Courses i.e. Become Data Analyst Course | Advanced Excel Course | Excel VBA Macro Tutorial

selected cells

Step 8: Now we can see the blank Columns are deleted. Now we need to delete the blank Rows.

select entire row

Step 9: Do again step 2 to step 5. Then right-click on the selected cells. The Pop-Up Menu will appear. Select Delete. Now from Delete box Check Entire Row to delete rows from the selection. Click OK.

remove blank cells result

See, all blank cells are deleted now. Happy data cleaning!

Read More: Tricks of text to column in MS Excel