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!
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!