Please help: how to apply filter function on only one window (multiple windows on a file)

%3CLINGO-SUB%20id%3D%22lingo-sub-2456407%22%20slang%3D%22en-US%22%3EPlease%20help%3A%20how%20to%20apply%20filter%20function%20on%20only%20one%20window%20(multiple%20windows%20on%20a%20file)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2456407%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20file%20that%20I%20am%20working%20on%20multiple%20windows%20(selecting%20from%20%22View%22%20-%20%22New%20Window%22%20in%20%22Window%20tab%22)%20with%20filter%20function.%20How%20can%20I%20use%20the%20filter%20function%20on%20a%20specified%20window%20and%20the%20filter%20does%20not%20happen%20on%20the%20other%20windows)%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3EKM%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2456407%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2456710%22%20slang%3D%22en-US%22%3ERe%3A%20Please%20help%3A%20how%20to%20apply%20filter%20function%20on%20only%20one%20window%20(multiple%20windows%20on%20a%20file)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2456710%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F689194%22%20target%3D%22_blank%22%3E%40Khanh_Mai%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20is%20not%20possible.%20If%20you%20have%20two%20windows%20on%20the%20same%20sheet%2C%20you%20can%20scroll%20them%20independently%20of%20each%20other%2C%20and%20change%20the%20view%20properties%20such%20as%20the%20zoom%20percentage%20independently%20of%20each%20other.%20But%20you%20will%20see%20exactly%20the%20same%20data.%20A%20filter%20is%20applied%20to%20the%20data%2C%20not%20to%20the%20window.%20So%20when%20you%20filter%20the%20data%20in%20one%20window.%20it%20will%20be%20filtered%20the%20same%20way%20in%20the%20other%20window.%3C%2FP%3E%0A%3CP%3EYou'd%20have%20to%20duplicate%20the%20worksheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello all,

 

I have a file that I am working on multiple windows (selecting from "View" - "New Window" in "Window tab") with filter function. How can I use the filter function on a specified window and the filter does not happen on the other windows)?

 

Thank you

Regards

KM

1 Reply

@Khanh_Mai 

That is not possible. If you have two windows on the same sheet, you can scroll them independently of each other, and change the view properties such as the zoom percentage independently of each other. But you will see exactly the same data. A filter is applied to the data, not to the window. So when you filter the data in one window. it will be filtered the same way in the other window.

You'd have to duplicate the worksheet.