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.
2. Then select Home > Find & Select > Go To Special.
3. Then the window Go To Special will appear, select an option Blanks. Click OK.
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.
Next a window will appear Delete, select an option Entire column to remove all empty columns.
6. The result will look like in the image below. All empty fields have been successfully removed.
#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.
2. Then select Home > Find & Select > Go To Special.
3. Then the window Go To Special will appear, select an option Blanks. Click OK.
4. Now, all empty rows will be selected as in the image below. Right click on worksheet, choose Delete as indicated by the arrow.
Next a window will appear Delete, select an option Entire row to remove all blank lines.
Or you can delete blank lines in another way by selecting Home > Delete > Delete Sheet Rows like in the picture below.
5. The result will look like in the image below. All blank lines have been successfully removed.
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!
“If you’re doing your best, you won’t have any time to worry about failure.” H. Jackson Brown, Jr.
Post a Comment for "2 Ways to Delete Blank Columns and Rows in Excel + Image"