The results of a pivot table (when clicking on it) generates a new worksheet.

1) I would like to format that new worksheet template. How ? and where is it ?
2) Some of the fields ae trucanting at 255 , how can I expand that ?


Any ideas?

Thank you kindly , in advance.

Hi Wilson,
255 is the maximum width of cell, you can turn on cell wrap either
by format, cells, alignment, wrap text
or by use of Alt+Enter which gets you a new line and an automatic wrap text formatting.
--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"WIlson" wrote in message ...
The results of a pivot table (when clicking on it) generates a new worksheet.

1) I would like to format that new worksheet template. How ? and where is it ?
2) Some of the fields ae trucanting at 255 , how can I expand that ?


Any ideas?

Thank you kindly , in advance.