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