Hi, I use excel 2016.
1. When I use Pivot table, how can I hide drop down buttons and still keep the first row.(If I remove the check mart "display field captions and filter drop downs", the first line also was hided). I want to keep the first heading and hide the buttons.
2. How can I choose the several different columns from data sources using Pivot Table. Each time when I select all items in rows, it always put under one by one. I want to it show in different columns in the pivot table.
Solved by B. Y. in 20 mins