excel filter not working on new rows

Then choose the Filter option from the drop-down list of the Sort Filter option from the Editing ribbon in the Home tab. Select t…