Tutorial on How to Easily Delete Blank Columns and Rows in Excel

Tutorial on How to Easily Delete Blank Columns and Rows in Excel

Geekers - Previously, we discussed how to remove duplicate data in Excel with the aim of helping with data processing or analysis. Apart from duplicating data, we also have to clean up empty data such as empty rows and columns in Excel data. This cleaning process is known as data cleansing.


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


   * Tutorial on how to move tables from Excel to Word

   * 3 Ways to Convert PDF to Excel Online and Offline

   * Tutorial on how to lock an Excel file with a password


How to Remove Blank Columns and Rows in Excel


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


List of contents

   * How to Remove Blank Columns and Rows in Excel

   + #1 Removing Blank Columns in Excel

   + #2 Removing Empty Columns in Excel


#1 Removing Empty Columns in Excel


See the steps for deleting empty columns below.



1. The worksheet block that will delete the empty column as shown below.


How to Delete Blank Columns and Rows in Excel 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 How to Delete Blank Columns and Rows in Excel 1


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


How to Delete Blank Columns and Rows in Excel How to Delete Blank Columns and Rows in Excel


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


How to Delete Blank Columns and Rows in Excel 3 How to Delete Blank Columns and Rows in Excel 3


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


How to Delete Blank Columns and Rows in Excel 4 How to Delete Blank Columns and Rows in Excel 4


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


How to Delete Blank Columns and Rows in Excel How to Delete Blank Columns and Rows in Excel


#2 Removing Empty Columns in Excel




See the steps for removing blank lines below.


1. The worksheet block that will delete blank lines as shown below.


Worksheet block Worksheet block


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


How to Delete Blank Columns and Rows in Excel 7 How to Delete Blank Columns and Rows in Excel 7


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


blanks blanks


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


Delete Delete


Next, the Delete window will appear, select the Entire row option to delete all empty rows.


How to Delete Blank Columns and Rows in Excel 9 How to Delete Blank Columns and Rows in Excel 9


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


How to Delete Blank Columns and Rows in Excel 11 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.


finals finals



That's all the discussion on how to delete empty columns and rows in Excel easily and quickly. All right, I hope the discussion that has been explained above is useful and good luck. Thank you!

Share:

Top Ads

Responsive Ads

Bottom Ads

Responsive Ads