Home / Computer / 2 How to Remove Empty Columns and Rows in Excel + Drawings

2 How to Remove Empty Columns and Rows in Excel + Drawings

Previously we discussed how to remove duplicate data in Excel in order to help the processing or data analysis. In addition to data duplication we must also clear empty data such as blank rows and columns in Excel data. This cleansing process is called data cleansing .

In the absence of blank rows and columns in the Excel file it will make it easier for you to use the data for a particular purpose as well as minimize data analysis or data mismanagement, right? Therefore, in this article we will discuss how to remove columns and blank lines in Excel. For more details, let's look at the explanation below.

How to Delete Empty Columns and Rows in Excel

Removing empty columns and rows in Excel is easy and simple. Firstly, we will discuss how to remove blank fields first then proceed by deleting blank lines.

# 1 Removing Empty Column in Excel

Notice the steps of deleting empty fields below

1. Block worksheet to be deleted as empty column as shown below.

 How to Remove Empty Columns and Rows in Excel

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

 How to Delete Empty Columns and Rows in Excel 1

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

 How to Remove Empty Columns and Rows in Excel

4. Well, all the blank columns will be selected as shown below. Right click on worksheet select Delete as pointed by the arrow.

 How to Remove Empty Columns and Rows in Excel 3

Next window will appear Delete select the option Entire column to delete all blank columns.

 How to Remove Empty Columns and Rows in Excel 4

The result will look like in the picture below. All blank columns have been removed.

 How to Remove Empty Columns and Rows in Excel

# 2 Removing Empty Columns in Excel

Notice the steps of deleting the blank lines below.

1. Block worksheet to be deleted empty line as shown below.

 Block worksheet

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

 How to Remove Empty Columns and Rows in Excel 7

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

 blanks

4. Now, all the blank lines will be selected as shown below. Right click on worksheet select Delete as designated by the arrow.

 Delete

Next will appear window Delete select option Entire row to remove all empty rows

 How to Remove Empty Columns and Rows in Excel 9

Or you can delete empty rows in another way by selecting Home > Delete> Delete Sheet Rows as shown below.

 How to Remove Empty Columns and Rows in Excel 11

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

 final

So many discussions on how to delete columns and blank lines in Excel easily and quickly. Well, hopefully the discussion described above is helpful and good luck. Thank you!

Loading...

Check Also

Get the Pixel 3 Night Sight on your Pixel, Pixel 2, or Pixel 3 right now

The new Night Sight camera feature Google unveiled at its recent hardware event is now …