Reapply Filter button (spreadsheet)
After editing the spreadsheet, use this button on the Home tab of the ribbon to reapply the current filter to the spreadsheet, including any changes you made.
Important! By design, Estimating does not apply the current filter to the changes you are making to the spreadsheet until you refresh the display by selecting the Reapply Filter button.
On the ribbon, from the Spreadsheet Display group on the Home tab, click the Reapply Filter button.