How To Remove Blank Rows In Excel

How To Remove Blank Rows In Excel

Excel is one of the prominent spreadsheet programs or suite offered by Microsoft that has received a warm welcome by all fields and sectors. Spreadsheets are application programs that enable users to store, retrieve and manipulate both numeric and alphanumeric data sets. Excel enables the creation of graphical representations and reports on numerical data sets. It’s more of number or digit oriented than text oriented MS Word. This is because Excel can perform statistical analysis on data stored in worksheets by use of simple and complex mathematical formulas. Its wide functions and commands that manipulate data are also excellent. Excel is thus usually customized for easy to use by any owner or user of a computer which has it installed. The application offers automation of tasks involved in manipulating both numeric and alphabetic data. Sometimes an excel worksheet can have empty rows that are not needed. Removing empty cells and Excel offers functionality to remove these rows that contain spaces or empty cells in them. Sometimes this can be done to enhance the compactness and continuity of the excel worksheet. If you have a few empty rows in excel, this is usually very easy to remove them. 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, in instances whereby hundreds of rows are sparsely present with some data in cells and others being empty, this can prove tiresome to delete each row one by one. Excel is thus a specifically crafted tool for this role as it is able to 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 work the operation in the worksheet for instances when this is to be done on many worksheets.

How to remove blank rows:

 

Step 1:

Ensure you have installed MS office into your laptop or computer. The office suite should also be updated for maximum user experience.

Step 2: Open EXCEL either by searching it via the search bar or navigate all through to its location.


Step 3:
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 4: Navigate and locate the “Editing “Group on the ribbon.


Step 5:
Then click on the ‘Find & select’ option in the group.

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


A drop-down menu with Find, Replace, Go To, Go To special, Formulas, Comments, data validation, as well as other options, will appear.

Step 6: 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 7:
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 8:
After the blank rows and cells are selected now move to the “cells” group and click on Delete.

The delete button in the cells group is clearly 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 9: Click on the “Delete Sheet Rows” option.

After clicking the delete sheet Rows options all rows with empty cells will be deleted or removed 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: