Introduction to removing rows in Excel

Introduction to removing rows in Excel

In this section of the Data Cleanup Online Course you will learn the various ways to remove unnecessary rows in Excel.

Whether it is blanks, or headers and footers that appear in the report, Excel prefers to just see the data. Even subtotals and totals need to be deleted.

Once you have it in an appropriate format you will be able to sort it, filter on it, run pivot tables and create charts with the newly cleaned data.

All these methods shown are based on the principle of getting the job done in the quickest and safest way. We also cover how to use tools and/ or formula to achieve the same thing. Tools are great for quick, once off deleting of unnecessary rows. Formula are better if you are trying to build a template to clean up a database on a regular basis.

So if you have something that looks like this, and all you want is the red block. Instead of spending the whole day manually deleting the unnecessary rows,

removing-unnecessary -rows

you can use tools or formula to get it to this within 5 minutes.

removing-unnecessary -rows

Or if you have something like this, with subtotals in various places which are useful in the final report, but not if this is a working copy and you want to analysis using something like Pivot Tables.

removing-unnecessary -rows

Again, in no time you should be able to turn it into this for further workings

removing-unnecessary -rows

Go to the next lessons to see how to do this

Back to: Data cleanup in Excel > Removing unnecessary rows