Tutorial Playlist

Excel Tutorial

Overview

Your One-Stop Solution to Know About Excel Worksheets

Lesson - 1

Your One-Stop Solution For Excel UserForms

Lesson - 2

The Best Guide on How to Send an Email in Excel

Lesson - 3

Your One-Stop Solution That Will Help You Learn How to Convert PDF to Excel

Lesson - 4

A One-Stop Solution for Acing the Excel MIS Report

Lesson - 5

All You Need to Know About Barcode in Excel

Lesson - 6

Your One-Stop Solution to Learn Mail-Merge in Excel and Its Implementation

Lesson - 7

A Comprehensive Guide on Excel Flash Fill

Lesson - 8

Slicers in Excel: The Ultimate Guide to Help You Design and Develop Excel Slicers

Lesson - 9

One-Stop Solution to Learn Everything About Excel Budget Template

Lesson - 10

All You Need to Learn About Match Function in Excel and Its Real-Time Implementation

Lesson - 11

Everything You Need to Learn on How to Create a Pivot Table From Multiple Sheets

Lesson - 12

The Major Fundamentals About XLookUp in Excel Along With Practical Examples

Lesson - 13

The Ultimate Guide to Learn How to Compare Two Columns in Excel

Lesson - 14

The Best Guide and Your One-Stop Solution to Master the Fill Series in Excel

Lesson - 15

What Is the DATE Function in Excel and How to Implement It?

Lesson - 16

Your One-Stop Solution to Designing and Implementing Hyperlinks in Excel

Lesson - 17

One-Stop Solution to Master Everything You Need to Know About Auto-Sum in Excel

Lesson - 18

DAX in Excel: The Complete Guide for DAX Functions and Formulas in Excel

Lesson - 19

A Perfect Guide for All You Need to Know About Data Formatting in Excel

Lesson - 20

The Perfect Guide to Learn How to Add Columns in Excel

Lesson - 21

The Perfect Guide That Will Explain to You How to Remove Page Break in Excel

Lesson - 22

The Perfect Guide to Explain to You How to Remove Blank Rows in Excel

Lesson - 23

The Perfect Guide to Learning How to Highlight Duplicates in Excel

Lesson - 24

One-Stop Solution Understand the Fundamentals of Indirect Function in Excel

Lesson - 25
The Perfect Guide to Explain to You How to Remove Blank Rows in Excel

Data Analytics critically relies on data cleaning for accurate results. Most of the time, the data is either incomplete or has irrelevant information, which could be special symbols or glitches that occur while collecting the data. Hence, cleaning data happens to be a tedious task.

This article on How to remove blank rows in excel will help you deal with one such scenario where you can try cleaning your data by eliminating all the blank rows in excel within a few simple clicks. 

PCP in Business Analysis

In partnership with Purdue UniversityVIEW COURSE
PCP in Business Analysis

How to Remove Blank Rows in Excel?

The original data will be visible as shown below. This sample data is based on employee details of a company. The data rows have some blank and incomplete data rows, which are deliberately included in the data for demonstration purposes.

We can try to clean the data in a few simple steps.

  • Step 1: Select the entire data as shown in the image below.

Remove_Blank_Rows_in_Excel_1.

  • Step 2: Navigate to the Home option on the toolbar, and search for the Find and Select option that looks as follows. 

Remove_Blank_Rows_in_Excel_2

  • Step 3: Click on the Find and Select option and choose the Go to Special option in the dropdown as shown below.

Remove_Blank_Rows_in_Excel_step3.

  • Step 4: In the new dialog box on the screen, select the blanks option as shown below.

Remove_Blank_Rows_in_Excel_4

Business Analyst Master's Program

Gain expertise in Business analytics toolsExplore Program
Business Analyst Master's Program

  • Step 5: All the blank cells and rows are selected in the dataset, as shown below.

Remove_Blank_Rows_in_Excel_5.

  • Step 6: Press the shortcut key combination CTRL + - (control/command key + minus key) to activate the delete option, as shown in the image below. Select the third option of deleting the entire row and press ok.
  • Step 7: The entire dataset is cleaned, and the blank rows were successfully eliminated, as shown in the image below.

Remove_Blank_Rows_in_Excel_6.

Kick-start your career growth story with our PGP in Business Analysis. Get a chance to master Excel, Tableau, and Python tools. Start learning now!

Next Steps

Highlight Duplicates in Excel can be your next step in learning the fundamentals of Microsoft Excel. Most scenarios expect the data analysts to highlight duplicate cells quickly and refine data. Learning the precise shortcut ways could be beneficial.

Interested to learn more about Business Analytics? Then consider visiting the Business Analytics certification course from Simplilearn. It is Ranked among the five topmost business analytics courses in the Industry. This Simplilearn program is a result-oriented training and certification program that helps you master statistics and data analytics concepts. 

Should you have any questions about this "How to Remove Blank Blank Rows in Excel" tutorial? Please feel free to write to us in the comments below. Our expert team will resolve them and will be happy to answer them at the earliest.

About the Author

Ravikiran A SRavikiran A S

Ravikiran A S works with Simplilearn as a Research Analyst. He an enthusiastic geek always in the hunt to learn the latest technologies. He is proficient with Java Programming Language, Big Data, and powerful Big Data Frameworks like Apache Hadoop and Apache Spark.

View More
  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.