Filtering an entire pivot table

%3CLINGO-SUB%20id%3D%22lingo-sub-2254043%22%20slang%3D%22en-US%22%3EFiltering%20an%20entire%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2254043%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20filter%20an%20entire%20pivot%20table%20as%20I%20used%20to%2C%20by%20clicking%20the%20upper%20left%20corner%20of%20the%20spreadsheet%20and%20then%20filter%2C%20so%20that%20all%20columns%20will%20show%20the%20drop%20down%20arrow%2C%26nbsp%3B%20Now%20I%20cannot%20do%20that%2C%20but%20I%20need%20to%20see%20information%20from%20different%20columns%20at%20the%20same%20time.%26nbsp%3B%20How%20do%20I%20do%20it%3F%26nbsp%3B%20Your%20help%20will%20be%20highly%20appreciated%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2254043%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi,

I am trying to filter an entire pivot table as I used to, by clicking the upper left corner of the spreadsheet and then filter, so that all columns will show the drop down arrow,  Now I cannot do that, but I need to see information from different columns at the same time.  How do I do it?  Your help will be highly appreciated

0 Replies