Ever worked with Excel documents only to find out later you have a lot of blank rows or even rows that contain blank cells? You can easily delete these rows using the Find and Replace feature in excel. Although having blank rows or cells within your excel worksheet is not considered bad, sometimes people find them unnecessary. More so when having such blanks make your document take up a lot of space than what you intended
Here we give you easy techniques on how to delete blank rows within your excel document. Let's get started.
Steps to follow when using FIND and REPLACE
1. On your computer, open your excel spreadsheet.
2. Click on the Home tab found in the main menu.
3. Go to the Editing group and click on the option Find & Select.
4. From the drop-down menu, click 'Go to Special.'
5. In the given dialog box, select 'Blanks.'
6. Click OK. After doing so, Excel selects and highlights all the blank cells within your worksheet.
If you only want to remove rows and not individual highlighted cells, you can always select a cell by clicking on Ctrl + Click. Doing so will deselect that particular cell.
7. Next, go to your Home tab, and in your Cells group, click Delete.
8. Here, a drop-down menu will be displayed. Click on the option Delete Sheet Rows.
It is good to keep on double-checking that you are only deleting the rows that you want. Having to select and delete individual cells will keep on moving the data below it up thus disrupting your Excel sheet workflow.
Steps to follow when you want to delete rows manually
You can easily delete rows in excel manually especially when they are a small number. To do this;
1. Select a row. You do this by clicking on the row number which is usually on the left side of your excel worksheet.
2. Right-click anywhere within the selected row.
3. Select Delete. After doing so, the selected row will be deleted. You can do this as many times as possible.
4. In case you want to delete blank rows that follow each other, click on the first row, then hold the Shift button and click on the last blank row.
5. In case of rows that are not consecutive, select them by using the CTRL key while clicking.
Deleting blank rows using filters
1. On your computer, open your excel worksheet.
2. Highlight the range of columns that contain all the rows you want to be deleted.
3. Go to the Data tab on the main menu and click Filter.
4. When you want to filter for the blank rows you have, click on the filter arrow in the first column, here, uncheck the option Select All, and check or select the option Blanks.
5. Click OK. Repeat the same method in all the remaining columns.
6. Afterward, select the filtered rows.
7. Go to the Home tab, select Delete > Delete Sheet Rows.
8. Lastly, clear the filters from the columns. After doing so, you will notice that all your blank rows are gone.