Question

what happens if you enter large amount of data in a narrow column what is the process of changing the column width​

Answer 1

Trick: How to change the default column width when refreshing a pivot table

Right-click in the pivot table.

Select Pivot Table Options.

In the Pivot Table Options dialogue box, click the Layout and Format tab, and then uncheck the box Autofit column widths on update.

do follow me