To turn sorting off and view data as it appears in the table, on the TABLE tab, in the Sort and Filter group, click Sort On/Off. To revert back to your last sort order, on the TABLE tab, in the Sort and Filter group, click Re-Sort.
To turn off filters, on the TABLE tab, in the Sort and Filter group, click Filters, and Clear Filter. You cannot revert back to your last filter.