Go to Data menu and click the Filter button.

click the drop down that appears in column A, select Text Filters and then Select Contains (or Begins With) and enter the word Total and click Ok.

Then select all the rows and then Right-click and select Delete Rows.

Then click the Filter button again to deactivate the filter... you should see no more Total rows.