Pivot table size issues

Copper Contributor

Hello,

 

I'm new to pivot table and using Excel 2019. I see that the Pivot table fields are very narrow in my version. And when I'm putting the columns, it shows scroll bars which is making it difficult to select the columns I used to play with as I'm hardly able to see anything.

 

How can I increase the size of these pivot table fields in my version so that these scroll bars are gone. Thanks for your help.

 

SKR1412_0-1677422595324.png

 

My current view looks like this - see pivot table fields.. Its very narrow and I'm not getting option to increase the size. I need it like the one given below in the screenshot.

 

SKR1412_1-1677422914838.png

 

I need like this.

SKR1412_2-1677423026301.png

 

Thanks for your help experts.

 

Kind Regards

SKR

1 Reply

@SKR1412 

Click on the gear icon for more layout options.

And you can click on the pane header and move the pane around.