Search This Blog

Delete Blank Rows Excel sheet

This example shows you how to delete blank rows or rows that contain blank cells.
1. On the Home tab, in the Editing group, click Find & Select.
delete blank rows excel
2- Click Go To Special.
delete blank rows excel
3-Select Blanks and click OK.
delete rows excel sheets
Excel selects the blank cells automatically blanks rows selected.
delete blank rows excel
4-On the Home tab, in the Cells group, click Delete then Click Delete Sheet Rows. .
delete blank cell

now all blank rows delete as blow 
delete blank rows