How can I, or is it even possible to remove the access to a filter on the Row Labels on a pivot table, see image for REF.

Or even just hide it from View

enter image description here

My pivot tablse set up only has Row Labels and Values

( Note. Games Won and Win Ratio is outside of the PIVOT )

enter image description here


Try right clicking on your pivot table > Pivot Table Options > Display > then uncheck the "Display field captions and filter drop downs" tick box

That should work.

  • Hiding in plain sight all along, only draw back is I cannot type in the cell, but i can live with that – PeterH Jan 12 '18 at 8:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.