Click to know how to show the Developer tab into Ribbon in Excel.
Note: By default, the Developer Tab is not shown in the Ribbon. Step 1: Before filtering the specified range, click the Developer > Record Macro. On the other hand, the macro is able to apply the filter criteria/view to other worksheets easily. Alternatively, recording a macro is a tricky way to save custom filter criteria in a specified range in Excel.