Skip to content Skip to sidebar Skip to footer

2 Ways to Delete Blank Columns and Rows in Excel + Image

Previously we have discussed how to remove duplicate data in Excel with the aim of helping the processing or data analysis. In addition to data duplication, we also have to clean up empty data such as empty rows and columns in Excel data. This cleaning process is referred to as data cleansing.

With no empty rows and columns in an Excel file, it will certainly make it easier for you to use the data for certain purposes and minimize analysis errors or data usage, right? Therefore, in this article we will discuss how to delete blank columns and rows in Excel. For further explanation, let’s see the explanation below.

How to Delete Blank Columns and Rows in Excel

Deleting blank columns and rows in Excel is quite easy and simple. First, we will discuss how to delete empty columns first and then continue with how to delete empty rows.

#1 Removing Blank Columns in Excel

Take a look at the steps to delete an empty column below.

1. Block worksheet the blank column will be deleted as shown in the image below.

How to Delete Blank Columns and Rows in Excel

2. Then select Home > Find & Select > Go To Special.

How to Delete Blank Columns and Rows in Excel 1

3. Then the window Go To Special will appear, select an option Blanks. Click OK.

How to Delete Blank Columns and Rows in Excel

4. Now, all empty columns will be selected as shown in the image below. Right click on worksheet, choose Delete as indicated by the arrow.

How to Delete Blank Columns and Rows in Excel 3

Next a window will appear Delete, select an option Entire column to remove all empty columns.

How to Delete Blank Columns and Rows in Excel 4

6. The result will look like in the image below. All empty fields have been successfully removed.

How to Delete Blank Columns and Rows in Excel

#2 Removing Blank Columns in Excel

Take a look at the steps for deleting blank lines below.

1. Block worksheet which will delete the blank line as shown in the image below.

Worksheet block

2. Then select Home > Find & Select > Go To Special.

How to Delete Blank Columns and Rows in Excel 7

3. Then the window Go To Special will appear, select an option Blanks. Click OK.

blanks

4. Now, all empty rows will be selected as in the image below. Right click on worksheet, choose Delete as indicated by the arrow.

Delete

Next a window will appear Delete, select an option Entire row to remove all blank lines.

How to Delete Blank Columns and Rows in Excel 9

Or you can delete blank lines in another way by selecting Home > Delete > Delete Sheet Rows like in the picture below.

How to Delete Blank Columns and Rows in Excel 11

5. The result will look like in the image below. All blank lines have been successfully removed.

final

That’s the discussion about how to delete blank columns and rows in Excel easily and quickly. Well, hopefully the discussion that has been described above is useful and good luck. Thank you!

Post a Comment for "2 Ways to Delete Blank Columns and Rows in Excel + Image"