How to freeze in a pivot table like in excel work sheet

[nevilledhamsiri]

Dear All,

Could you please show me the place, window or icon which will help me to do the freezing in a pivot table which of course look very long. Since the number of columns are larger, unless the table is freezed, it is very hard to see the results of the last columns. Like we do in excel, please show me where this is possible

Thanks in Advance

Neille

[dplr-rn]

Not 100% sure what you mean.

Generally the dimensions are frozen by default and if number of measures are high scroll bar comes only for the measures e.g. below

[nevilledhamsiri]

Hi Dilip,

As you said, scroll bar comes in certain instances but in my latest pivot table it does't come so that I have to drag the table & again adjust it using the bar below & so on. The issue is Scroll bar cannot be seen to use it & do the dragging

Any idea please

Thanks

[dplr-rn · Accepted solution]

based on my understanding of your reply (the browser scroll buttons are being used to scroll and not the pivot table ones)

that indicates the size of table is bigger that the screen. adjust the size of table to fit within the screen.

if i misunderstood a screenshot would help

[nevilledhamsiri]

Thanks Dilip,

May be this should be the case

Neville

[dplr-rn]

great. mark as helpful or answered if it worked