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.