How to Remove Blank Rows in Excel

How to Remove Blank Rows in Excel


How to Remove Blank Rows in Excel


How to Remove Empty Rows in Excel, Microsoft Excel has a very simple command to remove empty rows, as an example, we have shown to you through the pictures below that you can easily understand.



First, click on the Find and select option in the Editing section of the Home tab.




And click on Go To Special in it.



Then select the Blank option in it.



You will now see that all the empty rows have been selected.



Then in the Home tab, in the Cells section, click the Delete cells option.


In this, select Shift Cell Up.


You will see that all the cells that were empty will be deleted.



It was a simple trick to remove blank rows in Excel, and hopefully, after learning the trick, you will find the answers to the following questions.

How to remove blank rows in excel
How to delete blank rows in excel
How to delete empty rows in excel
How to remove empty rows in excel

Post a comment

0 Comments