Need help with the col width. Thanks

pedie

Well-known Member
Joined
Apr 28, 2010
Messages
3,875
I have created a PIVOT Table & the col width are very small. Whenever I drag and manually set it, after i do a selection it goes back to the normal small size.
Any idea why???:rolleyes:

Please help. Thanks.
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

pedie

Well-known Member
Joined
Apr 28, 2010
Messages
3,875
I set the col width manually to 50 but it went back..i know the reason why..it is because the cell value in short for eg: 123. If i write longer value in it works, bigger col width...but i just wanna know if there is a way to keep the col width bigger...:biggrin:
 

VaraK

Active Member
Joined
May 24, 2010
Messages
271
Something like this might help. This goes in the sheet module where the pivot table resides

Code:
Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
Range("A:Z").ColumnWidth = 50 'Specify your range here
End Sub

Hope this helps.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,681
Messages
5,833,087
Members
430,190
Latest member
beaviss

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top