To clear all the filters from the worksheet, click the "Clear" button in the Sort & Filter group on the Data tab. The rows will restore on the worksheet.