Clear Filter button (spreadsheet)

Use this button to remove the current filter from the spreadsheet sequence so that all items will appear on the spreadsheet.

On the ribbon, from the Spreadsheet Display group on the Home tab, click the Clear Filter button.