Pivot Table Drop downs and Field Caption.

srizki

Well-known Member
Joined
Jan 14, 2003
Messages
1,791
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
I am using slicer therefore I do not need drop down in my pivot table, but I cannot hide drop downs without hiding field caption. I need Field Caption.
Is there a way to keep Field Caption and hide drop downs.

Thanks

 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Watch MrExcel Video

Forum statistics

Threads
1,108,502
Messages
5,523,295
Members
409,508
Latest member
Afc

This Week's Hot Topics

Top