Pivot table confusion in excel 2007

  VNAM75 15:56 02 Sep 08
Locked

I've just installed excel 2007 (from 2003)and trying to create a pivot table. I have 4 fields in the Row area and instead of them being shown horizontally in cells A3:D3, they are all under column A and I have to drill down to see the data. The data is there but you don't know which field they relate to.
How can get it show the field names in the old pivot table format?

  VoG II 17:10 02 Sep 08

This may help click here

  VNAM75 19:30 02 Sep 08

Thanks VoG, I'd worked it out earlier but your link has the answer too and other useful information.

This thread is now locked and can not be replied to.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

1995-2015: How technology has changed the world in 20 years

The Pantone Colour of the Year 2017 is Green

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…