Pivot tables - selecting multiple fields from field list to appear in table

[scriwa]

Hi,

In Excel 2007, is there any way to highlight and select multiple fields from the "PivotTable Field List" at the same time? I realise you can 'tick' each field you want to enter, however, I have over a 100 and it would be useful if you could simply highlight the list!

Thanks!

 

[Herbert Seidenberg]

Excel 2007 PivotTable
Select all column fields at once,
using the "other" type of PT.
See PT type comparison here:
http://c0718892.cdn.cloudfiles.rackspacecloud.com/05_04_10.xlsx

 

[scriwa]

Hi there,

Many thanks for your reply, glad there's a solution!

Unfortunately, I'm not able to open the documents in the zip file and not sure what you mean about the "other type" of PT. Would you be able to provide any further info?

Once again, thanks for replying!

 

[Herbert Seidenberg]

Excel 2007 PivotTable
Comparison.
Try this link:
http://www.mediafire.com/file/z3dixw4ginm/05_04_10.xlsx
or
http://www.mediafire.com/file/dtvyymhyju5/05_04_10a.pdf

 

[Sandrine]

Thanks a lot. This works perfectly!!!!!

thanks!

 

[subbudas]

Hi Herbert,

Can you please elucidate how the"Other type" of PT works. How do you go about creating the filters - year, quarter,etc in the pivot table that has been created in the sheet that you suggested.

Looking forward to a quick response,

Best regards,
Subrat