ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Format pivot table / column width (https://www.excelbanter.com/excel-worksheet-functions/182199-format-pivot-table-column-width.html)

mcarter

Format pivot table / column width
 
How do I keep the column width the same after I select a new value in a pivot
table? after I select a new value to filter the data, it changes the column
widths and I have to change them back every time i select a new value to
filter.

Teethless mama

Format pivot table / column width
 
Highlight Pivot Table right click select Table Options tick on Preserve
formatting OK out


"mcarter" wrote:

How do I keep the column width the same after I select a new value in a pivot
table? after I select a new value to filter the data, it changes the column
widths and I have to change them back every time i select a new value to
filter.


mcarter

Format pivot table / column width
 
I have the preserve formatting on...

"Teethless mama" wrote:

Highlight Pivot Table right click select Table Options tick on Preserve
formatting OK out


"mcarter" wrote:

How do I keep the column width the same after I select a new value in a pivot
table? after I select a new value to filter the data, it changes the column
widths and I have to change them back every time i select a new value to
filter.



All times are GMT +1. The time now is 01:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com