Value Table Settings - Pivot Table

G

GWB2010

New Member
Joined
Sep 1, 2010
Messages
6
Is it possible using Excel 2007, to change the Value Table Settings in multiple columns at one time. I can change one column at a time but want "none" to apply to multiple columns. A kind of "formula Painter" would be ideal.

Thanks
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
You must log in or register to reply here.

Similar threads

J
  • Solved
Problems with Conditional Formatting in Pivot Tables in Excel 2024
Replies
3
Views
375
jfrsanders
J
C
  • Question Question
Transpose vertical CSV data set into a linked horizontal table with index match and/or lookup and multiple criteria
Replies
1
Views
83
Fluff
Fluff
I
  • Question Question
fixing number formats in pivot table
Replies
0
Views
308
INN
I
A
  • Solved
Automate data export from multiple word tables into excel
Replies
8
Views
450
NdNoviceHlp
NdNoviceHlp
J
  • Solved
VBA/Macro: Adding Pivot table with connection string
Replies
1
Views
475
Jette3173
J

Forum statistics

Threads
1,226,729
Messages
6,192,696
Members
453,747
Latest member
tylerhyatt04

Share this page

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
Back
Top