Showing Details from a Pivot Table

[shekala]

When I click on "Show Details" on a field in a pivot table, all the entries for that row appear on a new worksheet, which is great. However, the format of each column does not match the formatting of the columns in the data table. I have quite a few columns, so resetting the format for each column every time I want to see Details is cumbersome.

Is there a way to make the Show Details worksheet match the formatting of the underlying Data Table?

Thanks

 

[sheetspread]

This help?

https://blogs.office.com/en-us/2010...ables-to-match-source-data-power-tips-series/