pivot table formating

  1. X

    Pivot Value Number Formatting

    Hi All, This has been a peeve of mine for years so I finally decided to do something about it. I use pivot tables all the time and have to manually change the formatting of each field because I usually have both units and revenue in the same pivot. (Each needs a different format) I've built the...
  2. T

    Automated Headers and Footers when opening Pivot cells

    Hi all, I have learned a lot about excel in this forum and in other forums, but I now have a question that I have not found an answer to yet. I have been helping out our finance team/billing crew at the lab that I work at, and the problem we are experiencing rests on pivot tables. I have been...
  3. G

    Value Table Settings - Pivot Table

    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
  4. S

    Pivot table question regarding calculations

    I have a question about pivotables. In essence when I add a field to the pivot table it gives me a new field "sum of field" or "average of field" etc. It doesn't appear I can reference these values though. If I can I want to know how. I was thrying to find out the individual variation of each...
  5. A

    Removing "Sum of" from pivot table column labels

    Does anyone know how to remove "Sum of" out of pivot table column labels in 2007?

This Week's Hot Topics

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