pivottable format

  1. S

    Pivot table layout as tabular on right click

    Hello, I have excel 2016 pro plus (not 365). I have an option (3rd from top) when I right click on a pivot table which says 'Tabular, no-subtotals layout'. Don't get me wrong, I love it but I am completely lost as to how I got it. I must have changed something at some point but as far as I know...
  2. L

    PivotTable - Format Output of Clicked (sum) Data

    Hi! When you click the data points that are summed by a pivot table it produces a new sheet showing all of the data from that sum. Is there a way to automatically format this on the new sheet? Ideally what I would like to do is transpose the data to make it easier to view because the data...

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