How To Remove Blank Rows In Excel

Excel is one of the major spreadsheet programs or suites offered by Microsoft that has received a warm welcome from all fields and sectors. Spreadsheets are application programs that enable users to store, retrieve, and manipulate numeric and alphanumeric data sets.

If you have a few empty rows in excel, this is usually very easy to remove. To remove a single row in excel, you only need to click the row number at the leftmost side of each row that you want to remove. After the row is selected, you now right-click the highlighted row, and it will be automatically deleted according to your wish.

However, instances where hundreds of rows are sparsely present with some data in cells and others being empty, can prove tiresome to delete each row one by one. Excel is thus a specifically crafted tool for this role as it can eliminate blank rows by automatically finding them from the worksheet that the user is currently working on. Excel can detect the blank cells all by itself, which speeds up the work of the operation in the worksheet, for instance, when this is to be done on many worksheets.

How to remove blank rows:

Step 1: Open the excel file that you want to manipulate by clicking on it.

This is done by clicking the file tab and selecting your recent or navigating to your document of choice. When you find the file, click it and patiently wait for it to load.

This will start the initiation and loading of the excel file. On loading, the excel documents will load the first worksheet in default. If this is your suitable worksheet option or choice, then you can continue working on it.

The document will now be at the home tab by default.

Step 2: Navigate and locate the "Editing "Group on the ribbon.

Step 3:
Then click on the 'Find & select' option in the group.

Note that collections of related commands with icons are enclosed in group boxes known as groups. Each group has a unique name related to its command icons.

A dropdown menu with Find, Replace, Go To, Go To Special, Formulas, Comments, data validation, as well as other options, will appear.

Step 4: Select the option for "Go To Special" from that dropdown menu that will be displayed.

A dialog with checkboxes and round buttons will appear. The dialog will also have two buttons, the 'OK' and the 'Cancel' Button, as below.

Step 5:

So click the option at the bottom left of the dialog named "Blanks" and press the OK button. The OK button should now initiate a window displaying selected blank rows.

Step 6:
After selecting the blank rows and cells, move to the "Cells" group and click on Delete.

The delete button in the cells group is identifiable with a red "X" in its Icon.

Clicking on it will display a dropdown menu with the options: Delete cells, Delete sheet Rows, Delete Sheet Columns and Delete sheet, in that manner as below.

Step 7: Click on the "Delete Sheet Rows" option.

After clicking the delete sheet Rows options, all rows with empty cells will be deleted, leaving only complete rows.

However, always be careful when deleting data from cells as some may be crucial, and this would require you to go for other options of removing blank cells.

This will result in the following: