Changing column width Activate the pivot table. Click and drag the column border. To view hidden borders in a pivot table, from the View menu choose Gridlines.