Pivot with extended table for manual input.

[Devonair]

Hi everyone,

I would like to ask on how to make extra rows on a pivot table?. I've seen this one excel file which there is a Pivot table and on its right side there's an extra rows that you can enter data on it. It looks like a part of Pivot table but right clicking on its cells and headers there is no Refresh option to it. And I can freely enter any value with it.


Thank you again.

 

[James006]

Hi,

Just use the Design Tab ...

see https://support.office.com/en-us/ar...vottable-a9600265-95bf-4900-868e-641133c05a80

Hope this will help