Crosstab question

Panorama X
1

When crosstabs contain too many rows & columns to display all data, column headers scroll out of view when scrolling down while row headers scroll out of view when scrolling right.

Is there a way to keep row & column headers always visible while scrolling up/down & left/right so that scrolling only affects the actual data?

“AI Overview” claims that (a) selecting the first column, (b) opening the Object Properties panel, (c) find the Fixed Position or Fixed Header/Column option, and (d) setting it to Left or True should accomplish this but I have not been able to do this and wonder if this is even real.

2

When the cross tab contains too many rows to display all of the data, scrolling up and down DOES NOT affect the column headers. They remain in place when scrolling down. I don’t know why you are saying that they scroll out of view.

However, if the crosstab contains too many columns, then yes, scrolling to the right does cause the first column to scroll off the window. There is no setting to override that. As far as “AI Overview” goes, it is worth every penny you paid for it - i.e. nothing.