Remove the "values" button from a pivot table

[Thrive]

Could someone help me how to remove the "values" button in a pivot table? Please refer to the screenshot below. Thanks.

[vincent_ardiet_ · Accepted solution]

I don't think this is possible unless you use an external extension like Vizlib pivot which has such options.

[aruneshgupta]

Hi, You can not remove search option but you can keep it blank using chr(10) in column label. 

Best Regards,

Arunesh

[Thrive]

Thanks for your prompt response! I don't have access to the Vizlib extension.

[Thrive]

Hi @aruneshgupta  Thanks for your reply. But, I'm not asking to remove the search option. I want to remove the "values" button as highlighted in the screenshot. Thanks.

[aruneshgupta]

Then it should go away after using chr(10) in label.