How to get classic pivot table view in Excel 2010

For those of you who are used to pivot tables in Excel 2003/2007 like me, these are the steps to get the classic look for pivot tables in Excel 2010. I don't know about you but I still like the familiar look and feel from Excel 2003.


Difference between the new and classic pivot table: The new version group the Row Labels together (I don't usually want that)

Right click ON the pivot table --> PivotTable Options

Click Display tab and check Classic PivotTable layout

We are not done yet, if you want to see merged cells for grouped rows:
Click ON the Pivot table again--> Click Design on tool bar

On PivotTable Styles, click on the bottom down arrow to expand all styles and click Clear
There you have it! Classic pivot table view