Excel Guides

Setting Stable Column Widths in a PivotTable in Excel

PivotTables are a great way to summarize data in Excel, but one common problem is that the column widths can change when you refresh the data or add new fields. This can make it difficult to read the data, especially if you have a lot of columns. Luckily, there is a way to set the column widths so that they stay the same, no matter what changes you make to the data.

To set stable column widths in a PivotTable, first select any cell in the PivotTable. Then, go to the PivotTable Tools tab on the ribbon and click Options. In the PivotTable Options dialog box, go to the Layout & Format tab and check the box next to "Preserve cell formatting on update". This will ensure that your column widths are preserved when you refresh the data or add new fields.

You can also use this method to set a specific width for each column. To do this, select a cell in the column that you want to resize and then drag the edge of the column to the desired width. Once you have all of your columns resized, go back to the PivotTable Options dialog box and check the box next to "Preserve cell formatting on update". This will save your custom column widths so that they are not changed when you refresh the data.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.