Showing results for 
Search instead for 
Did you mean: 

Freezing header row in pivot table

8 - Cloud Apps
8 - Cloud Apps


I've researched the past discussions for this question and did see that the advised solution was to disable the pivot table's Auto Height setting and adjust the height of the widget until a scroll bar appears for the pivot table, separate from the dashboard's scroll bar.

In testing this solution, I've found that it is difficult to scroll to the bottom of the pivot table's scroll bar and view grand totals without also scrolling down on the dashboard, requiring the user to scroll back up in the dashboard to view the bottom of the pivot (see "Pivot_ScrollBars" attachment for how this generally looks). This is the main usability issue I've identified with the advised solution, so I'd like to see if there may be another way to accomplish freezing a pivot's header row which could potentially avoid this.

Thank you!