Name: How to remove blank rows in Excel
Uploaded: 2023-03-05T14:57:12.000Z
Duration: 18 s
Description: In this Excel tip, we’ll show you a quick way to remove those blank rows in Excel that you don’t need. This tip can be helpful if you have a lot of data that you want to hide, or if you just don’t want to see the blank rows.

In this Excel tip, we’ll show you a quick way to remove those blank rows in Excel that you don’t need. This tip can be helpful if you have a lot of data that you want to hide, or if you just don’t want to see the blank rows.

Microsoft Excel

I'm a Microsoft MVP, the Chief Operating Officer at OnTheClock, an employee time tracking software, with an MBA from Macquarie University and have an extensive background in analyzing and solving problems. 

I've worked in automotive, biotech, pharmaceuticals, luxury consumer goods and now SaaS. Let me show you how to incorporate Excel into your work to make it easier and actionable. 

How to remove blank rows in Excel

eceedcf3-ac5a:37756;isclassifiedstrendingsuggestionsenableddt:42136;316f64c0-2415:46048;b2454379-d6cf:44572;335d7519-3303:46159;31885555-099a:47313;9979286f-d859:47315;i9de8100:55497;ei83g319:53872;596id705:58363;fg008402:58376;i6jj6667:86739;istutorredesignv2_1:73124;2b6i0532:68197;a5gbd220:61179;blogpwt:71359;5db3b892:67466;2a2j8400:70238;b534g232:70741;j91hb444:69773;18h21436:69961;85h98405:81245;0eie7335:76839;cia78296:75037;9b4gd804:78753;4d465237:81260;deisn977:110326;1d789912:110325;slcardst:87990;searchranking_newpqs:91321;b1ff5649:88417;d9c7i206:87231;ajgj0920:88926;dgigc739:92611;15gbg809:92228;3cf2h499:95552;90ahj157:94513;3d835968:100010;gg41j822:94817;3i5dg498:97157;437bb176:97771;06ieg414:100430;9ab7j510:99496;a0ge6769:101092;bfb37872:105751;7f8gg909:114000;eh7a9388:114646;

Beginner

Intermediate

Advanced

Chief Operating Officer

I take complex frameworks, formulas and concepts and simplify them to apply to real-life business cases to solve problems. 

I have about 300k followers learning Excel and Sheets tips and tricks on various social platforms.

Editor and Founder

Quick, concise lessons in manageable chunks to make it easy to learn.

Learn how to use slicers to control your various charts creating a nice dashboard.

Excel interactive dashboard tutorial

Custom Excel Bar Chart Tutorial

Learn how to make an Excel McKinsey Chart or chart within cells.

Excel McKinsey Chart or Chart Within Cells

Learn how to use check boxes in Excel to create a tool to track project progress.

Excel project tracking tool

Learn how to use Excel to create an inventory dashboard using pivot tables, slicers, icons, shapes, pie charts.

Excel inventory dashboard tutorial

Excel dashboard tutorial with pivot charts, bar charts and slicers.

Excel dashboard with pivot charts, bar charts and slicers

Learn how to create a Multi stage progress bar in Excel.

Multi stage progress bar in Excel

Excel Gantt Chart Tutorial

Finish up the dashboard with data bars and bar chart.

Excel dashboard tutorial part 2 of 2

Learn how to add slicers, icons, shapes and pivots to this dashboard. Part two goes  more into the data bars and bar charts.

Nicole H.

How to remove blank rows in Excel

Nicole's Microsoft Excel videos

Excel interactive dashboard tutorial

Custom Excel Bar Chart Tutorial

Excel McKinsey Chart or Chart Within Cells

Excel project tracking tool

Excel inventory dashboard tutorial

Excel dashboard with pivot charts, bar charts and slicers

Multi stage progress bar in Excel

Excel Gantt Chart Tutorial

Excel dashboard tutorial part 2 of 2

Excel dashboard tutorial part 1

Radial bar chart in Excel

Excel Macros to automate work

Teacher Reviews

Book online lesson

How to Use ROW Function in Microsoft Excel

How to Take Screenshot Using Microsoft Excel In-Built Camera

How to Use RANK Function in Microsoft Excel

Excel interactive dashboard tutorial

How to Use VSTACK Function in Microsoft Excel

How to Insert a Empty Row After Each Row in Microsoft Excel

Custom Excel Bar Chart Tutorial

How to Create Folders for the List of Names using Microsoft Excel

How to Remove Spaces in Words In Microsoft Excel

How to Create Colorful Dropdown List Using Data Validation in Microsoft Excel

Related Subjects